1.语法:alter 表名 add|drop|change|modify column 列名 类型
2.change是修改列名,modify是修改某一个列的值
3.代码:
ALTER TABLE book CHANGE COLUMN publishDate pubDate DATETIME;
ALTER TABLE book MODIFY COLUMN pubDate TIMESTAMP;
ALTER TABLE book ADD COLUMN authorName VARCHAR(20);
ALTER TABLE book DROP COLUMN authorName;
ALTER TABLE author RENAME TO book_author;