mysql 语句

use interface_scan3;

-- 新增一列
alter table data_check_app_page add column is_valid int(10) unsigned NOT NULL DEFAULT 1 after interface_id;

-- 调整列顺序
alter table data_check_app_page modify is_valid int(10) unsigned NOT NULL DEFAULT '1' after interface_id;
原文地址:https://www.cnblogs.com/jec1999/p/9871206.html