mysql三

修改字段名

mysql> alter table users change id user_id INT UNSIGNED  AUTO_INCREMENT;

修改字段类型

mysql> alter table users change user_id user_id INT UNSIGNED  AUTO_INCREMENT;

 HAVING

汇总函数

WITH ROLLUP

多个数据表的查询

LEFT JOIN

子语句

DELETE

UPDATE