在另一列之后添加列
问题描述：
如何使用Alembic或SQLAlchemy在数据库的另一列之后添加一列?相当于此SQL子句:
How can I add a column after another column to a database using Alembic or SQLAlchemy? That would be equivalent to this SQL clause:
ALTER TABLE foo
CHANGE COLUMN bar
bar COLUMN_DEFINITION_HERE
AFTER OTHER_COLUMN;
-- or
ALTER TABLE foo ADD COLUMN baz AFTER bar;
我还在此邮件列表主题中尝试了该建议，但没有帮助.
尽管查询时顺序无关紧要，但在SQL shell中，它有助于大型表的可读性.
While the order doesn't matter when querying, it helps readability for large tables when in the SQL shell.
答
尝试以下查询:
ALTER TABLE表名添加新的列名column_definition AFTER column_name;
ALTER TABLE table_name ADD New_column_name column_definition AFTER column_name;