mysql 小记

最新推荐文章于 2024-09-18 00:24:42 发布

宇文仲竹

最新推荐文章于 2024-09-18 00:24:42 发布

阅读量65

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/glc22/article/details/119185709

版权

SQL 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1.表字段内容备份更新

借助临时表实现临时存储，将表字段的内容重新整理成一行，并将内容存入原来表中

--https://blog.csdn.net/luohao199621/article/details/89356562
--https://blog.csdn.net/jiankunking/article/details/52626449
DELIMITER $$   
  

drop PROCEDURE IF EXISTS backCameraAreaExInfo; 
CREATE  PROCEDURE backCameraAreaExInfo()
BEGIN   
	create table bc_temp as
	  select F1, group_concat("[",F2,",", F3,",", F4,",", F5,",", F6,",", F7,",", F8,",", F9,",", F10,",", F11,",", F12,',"', F13,'"]') as value
		from CameraAreaExInfo group by F1;
	delete from CameraAreaExInfo;
	insert into CameraAreaExInfo(F1,F2) select F1, value as F2 from bc_temp;
END  $$    

DELIMITER ; 
call backCameraAreaExInfo();