1.alter table :添加、删除、修改列:
添加列:ALTER TABLE table_name ADD column_name datatype
删除列:ALTER TABLE table_name DROP COLUMN column_name
修改列:ALTER TABLE table_name ALTER COLUMN column_name datatype
重命名列:ALTER TABLE 【表名】 CHANGE 【列名】【新名】
修改数据字段类型:ALTER TABLE Persons ALTER COLUMN Birthday year
修改表名:ALTER TABLE tbl_name rename new_tbl_name
创建索引:ALTER TABLE tbl_name ADD INDEX index_name (column list)
删除索引:ALTER TABLE tbl_name DROP INDEX index_name (column list)
删除列:ALTER TABLE Person DROP COLUMN Birthday