不行只能新加字段然后改名了
首先添加新列:
ALTER TABLE tx_m_dimension_field
ADD COLUMN c_order_new INTEGER NULL;
更新数据:
UPDATE tx_m_dimension_field
SET c_order_new = c_order;
删除原列并重命名新列:
ALTER TABLE tx_m_dimension_field DROP COLUMN c_order;
ALTER TABLE tx_m_dimension_field CHANGE COLUMN c_order_new c_order INT…