MySQL 已有数据的表 调整字段顺序
目的
解决
生成一张字段顺序正确的表,把以前那张表的数据复制过去
生成一张正确结构的表,pms_goods_sku_stock2
查询表的所有字段
select
COLUMN_NAME
from information_schema.COLUMNS
where table_name = 'pms_goods_sku_stock2'
and table_schema = 'blade2';
复制的sql语句
insert into 表1 (列名1,列名2,列名3) select 列1,列2,列3 from 表2
生成的sql
insert into pms_goods_sku_stock2
(
id,product_id,goods_id,store_id,product_name,goods_name,name,store_name,primary_store_name,sp_data,sku_code,price,sale_price,all_sale_price,all_sale_price_update_time,profit,sale,stock,low_stock,pic,related_sale,related_product_id,related_product_name,real_num,sort,remark,create_user,create_time,update_user,update_time,status,is_deleted,tenant_id
)
select
id,product_id,goods_id,store_id,product_name,goods_name,name,store_name,primary_store_name,sp_data,sku_code,price,sale_price,all_sale_price,all_sale_price_update_time,profit,sale,stock,low_stock,pic,related_sale,related_product_id,related_product_name,real_num,sort,remark,create_user,create_time,update_user,update_time,status,is_deleted,tenant_id
from pms_goods_sku_stock
remark
中间截图的时候 缺了一个字段