- 簡單查詢 ~~~ set names utf8; 設置編碼 select * from biao 基本查詢 select distinct id from biao 結果字段不重復 select * from biao order by id desc ,time asc; 升序降序 select * from biao group by sex having; 分組篩選 select * from biao limit 4 返回4條 select * from biao 4,3 返回3條,從第5條記錄開始 select a,b,c from A inner join B on A.id = B.id; 內連接 select a,b,c from A,B where A.id=B.id;內連接 select * from A left join B on A.id=B.id; 左連接 select * from A right join B on A.id=B.id;右連接 select id from Table where id2 in(select id3 from Table2) 子查詢 select id from Table where find_in_set(type,"ssq,sd,pls") 查詢分類 select id as ID from A as a 別名 select * from A union all select * from B 合并結果集 select * from A union select * from B 去重復 SELECT id,title FROM article WHERE id<$id ORDER BY id desc LIMIT 1 上一篇 SELECT id,title FROM article WHERE id>$id ORDER BY id ASC LIMIT 1 下一篇 select count(distinct openid) as total from TB 統計記錄去重復 ~~~