Mysql 清理表， 调整group列记录

# 基础表8个
TRUNCATE t_org;
TRUNCATE t_shops;
TRUNCATE t_equipment_info;
TRUNCATE t_shopping_receipt_template;
TRUNCATE t_receipt_daily_template;
TRUNCATE t_receipt_template_menu;
TRUNCATE t_receipt_template_ticket;
TRUNCATE t_receipt_template_replace;

alter table t_org AUTO_INCREMENT=1000000;
alter table t_shops AUTO_INCREMENT=1000000;
alter table t_equipment_info AUTO_INCREMENT=1100000;
alter table t_shopping_receipt_template AUTO_INCREMENT=1000000;
alter table t_receipt_daily_template AUTO_INCREMENT=1000000;
alter table t_receipt_template_menu AUTO_INCREMENT=1000000;
alter table t_receipt_template_ticket AUTO_INCREMENT=1000000;
alter table t_receipt_template_replace AUTO_INCREMENT=1000000;

alter table t_shops_alarm AUTO_INCREMENT=1000000;
alter table t_shops_qrcode AUTO_INCREMENT=1000000;

 

      SET GLOBAL group_concat_max_len=102400;
       SET SESSION group_concat_max_len=102400; 

 

#列名
select COLUMN_NAME from information_schema.columns
where TABLE_SCHEMA='yunpiaobox_db' and table_name='t_announcement'

#列名字符串 按,分隔
select
GROUP_CONCAT(COLUMN_NAME separator ',') '逗号分隔',
GROUP_CONCAT(CONCAT('OLD.', COLUMN_NAME) separator ',') 'OLD.字段 逗号分隔',
GROUP_CONCAT(CONCAT('NEW.', COLUMN_NAME) separator ',') 'NEW.字段 逗号分隔',
GROUP_CONCAT(CONCAT(COLUMN_NAME, '=NEW.', COLUMN_NAME) separator ',') '字段=NEW.字段 逗号分隔'
from information_schema.columns
where TABLE_SCHEMA='yunpiaobox_db' and table_name='t_shopping_receipt_content'