mysql查询语句

单表查询: SELECT * FROM table_name;

单表指定字段查询: SELECT id, user_id FROM table_name;

单表指定查询条件查询: SELECT * FROM table_name WHERE id > 2;

多表查询: SELECT * FROM table_name, table_name1;

多表指定字段查询: SELECT table_name.id, table_name1.id FROM table_name, table_name1;

多表指定查询条件查询: SELECT * FROM table_name, table_name1 WHERE table_name.id > 1 and table_name.id = table_name1.id;

单字段分组查询: SELECT * FROM table_name GROUP BY sex;

多字段分组查询: SELECT * FROM table_name GROUP BY sex, age;

多字段分组字段详情查询: SELECT GROUP_CONCATE(userid) FROM table_name GROUP BY sex, age;

多字段分组最大userid查询: SELECT MAX(userid) FROM table_name GROUP BY sex;

多字段分组最小userid查询: SELECT MIN(userid) FROM user GROUP BY sex;

多字段分组平均age查询: SELECT AVG(age) FROM user GROUP BY sex;

多字段分组age和查询: SELECT SUM(age) FROM user GROUP BY sex;

分组查询子查询: SELECT userid FROM user GROUP BY sex HAVING userid < 50;

分组查询子查询多字段: SELECT userid, age FROM user GROUP BY sex HAVING userid < 50 AND age < 20;

查询结果排序id倒序: SELECT id FROM user ORDER BY id DESC;

查询结果排序id升序(默认): SELECT userid FROM user ORDER BY userid ASC;

查询结果分页: SELECT userid FROM user ORDER BY userid ASC LIMIT 0, 10;

内连接查询: SELECT * FROM user as u JOIN userCode as c ON u.userid = c.userid

左外链接查询: SELECT u.userid, c.code FROM user as u LEFT JOIN userCode as c ON u.userid = c.userid limit 10

右外链接查询: SELECT u.userid, c.code FROM user as u RIGHT JOIN userCode as c ON u.userid = c.userid limit 10