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);