想删除某个表中某个字段的unique key:
ALTER TABLE good_booked DROP INDEX good_id;
添加字段:
ALTER TABLE test ADD COLUMN id INT UNSIGNED NOT NULL auto_increment PRIMARY KEY FIRST
转载于:https://www.cnblogs.com/iszhangheng/p/10243436.html