mysql的建表语句

1.启动mysql服务

net start mysql

2.停止mysql服务

net stop mysql 

3,查看表结构

desc tableName;

4.建表后忘增加主键

alert table user add primary key (uid);

5.修改主键为自增长

alert   table  user modify uid int auto_increment;

6,插入语句

insert into user (uname,upwd) values('ccc','123');

7.排序

select * from user order by  uid desc(或asc);