mysql
跟着哥哥学魔法
成大事者,不拘小节!
展开
-
mysql中使用sql根据相同字段合并值
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_nofrom order_temp_001原创 2020-09-09 18:36:05 · 2536 阅读 · 0 评论 -
mysql的不同数据库的两表双向触发器
-- 两表双向增加触发器delimiter //-- DROP TRIGGER IF EXISTS admin_insertCREATE TRIGGER admin_insert AFTER INSERT ON hotmine.admin FOR EACH ROWBEGIN IF NOT EXISTS ( SELECT * FROM hotmine_new.admin WHERE hotmine_new.admin.id = new.id ) THEN INSE...原创 2020-08-01 14:57:44 · 383 阅读 · 0 评论