排序
ORDER BY
LIMIT限制显示条数
SELECT*FROM cms ORDER BY id DESC LIMIT5;
UPDATE cms SET age=age+10 LIMIT 3；
连接查询
内连接
INNER JOIN provinces AS p
ON u.proId=p.id;
外连接
LEFT JOIN
RIGHT JOIN
外键
保证数据完整性一致性，建立主表和副表的关系。
相同的存储引擎，相似的数据类型，数字长度和是否有符号位必须相同。首先先创建索引。
FOREIGN KEY(depId)REFERENCES department(id)
创建CONSTRAINT
删除DROP FOREIGN KEY
联合查询
UNION去掉相同记录
UNION ALL简单合并
SELECT username FROM employee UNION SELECT username FROM cms_user
子查询
SELECT id，username FROM employee WHERE depId IN(SELECT id FROM department)
7万+
