sql加柱之后的另一个
ALTER TABLE myTable ADD myNewColumn VARCHAR(255) AFTER myOtherColumn
sql改变表中添加列如果存在的话
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'table_name' AND COLUMN_NAME = 'col_name')
BEGIN
ALTER TABLE table_name
ADD col_name data_type NULL
END;