修改
ALTER TABLE TableName CHANGE Field_name_tobe_change new_Name VARCHAR (32);
删除
ALTER TABLE TableName DROP Field_name_tobe_delete
ALTER TABLE TableName CHANGE Field_name_tobe_change new_Name VARCHAR (32);
删除
ALTER TABLE TableName DROP Field_name_tobe_delete
确实是ALERT
ALTER TABLE TableName CHANGE Field_name_tobe_change new_Name VARCHAR (32);
删除
ALTER TABLE TableName DROP Field_name_tobe_delete
重命名
ALTER TABLE TableName rename as newTableName
或者用ALTER TABLE TableName DROP [COLUMN] col_name;
如果不想更改字段名用modify不是更好吗?