Java学习-MySQL-修改和删除数据表字段

Java学习-MySQL-修改和删除数据表字段

-修改表名
ALTER TABLE student RENAME AS teacher
-增加字段
ALTER TABLE teacher ADD age INT(3)
DESC teacher

-修改字段
-法1：修改约束
-将类型从int改为varchar
ALTER TABLE teacher MODIFY age VARCHAR(3)
DESC teacher

-法2：重命名
-将age重命名为agegae，类型改回int
ALTER TABLE teacher CHANGE age ageage INT(3)
DESC teacher

-删除字段
ALTER TABLE teacher DROP ageage
DESC teacher

-删除表
DROP TABLE IF EXISTS teacher