【MySQL必知必会】第四章 检索数据（学习笔记）

检索列

说明：COLUMNNAME 列名，TABLENAME 表名

1. select COLUMNNAME from TABLENAME;
2. select COLUMNNAME1,COLUMNNAME2 from TABLENAME;
3. select * from TABLENAME;

检索列去重distinct

1. select distinct COLUMNNAME from TABLENAME;
2. select distinct COLUMNNAME1,COLUMNNAME2 from TABLENAME;(同时满足COLUMNNAME1与COLUMNNAME2相同会被识别为重复记录)

限定行limit

1. select COLUMNNAME from TABLENAME limit 1;
2. select COLUMNNAME from TABLENAME limit 2,1;=select COLUMNNAME from TABLENAME limit 1 offset 2;

字段限定表名

1. select TABLENAME.COLUMNNAME from TABLENAME;