mysqlsql语句总结

createdatabasemytestdefaultcharset=utf8//创建数据库
createtableusers//创建表
(
user_idintnotnullauto_increment,
user_namevarchar(20)notnull,
descriptionvarchar(200),
primarykeyPK_userid(user_id)
);
showcreatetableusers;//查看创建表的sql语句
descusers;//查看表结构
altertableusersadd(user_ageintnotnull);//添加表字段
insertintousers(user_name,description,user_age)values("chen","thisisgoodmen.",28);//插入一条数据
//查询数据库
select*fromuserslimit5;//查询前5条
SELECT*FROMusersLIMIT6,2;//从弟6条开始，查2条