qq_40948117的博客

1、GROUP_CONCAT函数的用法 这是原始表 这是通过group_concat函数从查询出来的数据 sql语句： select a.sales_order_no, REPLACE(GROUP_CONCAT(a.external_order_no),’,’,’ / ‘) as external_order_no, REPLACE(GROUP_CONCAT(a.original_order_no),’,’,’ / ') as original_order_no from order_temp_001

-- 两表双向增加触发器 delimiter // -- DROP TRIGGER IF EXISTS admin_insert CREATE TRIGGER admin_insert AFTER INSERT ON hotmine.admin FOR EACH ROW BEGIN IF NOT EXISTS ( SELECT * FROM hotmine_new.admin WHERE hotmine_new.admin.id = new.id ) THEN INSE...