题解 | #修改表#

ALTER TABLE user_info ADD COLUMN school VARCHAR(15) AFTER level;
ALTER TABLE user_info CHANGE COLUMN job profession VARCHAR(10);
ALTER TABLE user_info CHANGE COLUMN achievement achievement int DEFAULT 0;
ALTER TABLE user_info MODIFY COLUMN achievement INT DEFAULT 0;

• 3和4的效果一致