修改表名

ALTER TABLE 旧表名 RENAME AS 新表名;

  1. ALTER TABLE teacher RENAME AS teacher1;

增加字段

  1. ALTER TABLE teacher1 ADD age INT (11);

修改表字段

  1. ALTER TABLE teacher1
  2. MODIFY age VARCHAR(11);

修改字段名

  1. ALTER TABLE teacher1 CHANGE age ag1 INT(1);

删除字段

  1. ALTER TABLE teacher1 DROP age1;

删除表

  1. DROP TABLE IF EXISTS teacher1;