目录
一.目的
1.想:提高学习效率,所以将老师的内容记录下来
二.参考
1.SIKI学院
三.注意
1.课程资源下载
1.MySQL下载地址
MySQL :: Download MySQL Installer (Archived Versions)
- good:官网的,和老师保持一致。
四.操作:成功
1.查看表:*的意思是是所有列
select *from mytable limit 4;
select *from mytable limit 2,3;
select username from mytable;
select username from mytable where id>8;
select username,password from mytable where id>8;
select *from mytable order by id;
select *from mytable order by id desc;
select *from mytable order by id desc limit 1;