alter table添加列
ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;
sql server alter列
ALTER TABLE table_name
ALTER COLUMN column_name new_data_type(size);
alter table column将数据类型更改为text mysql
ALTER TABLE tablename MODIFY columnname INTEGER;
如何在mysql中更改表列名
ALTER TABLE your_table_name RENAME COLUMN original_column_name TO new_column_name;