使用sql批量生成mysql的insert语句

最新推荐文章于 2023-07-15 00:12:36 发布

Mr.Z_z

最新推荐文章于 2023-07-15 00:12:36 发布

阅读量1k

点赞数

分类专栏： mysql 文章标签： mysql db

本文链接：https://blog.csdn.net/hety119/article/details/108100604

版权

mysql 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

select  concat('insert into test.test123(id,name,name2) values(','uuid(),','uuid(),','uuid())') t  from oper_log limit 10;

select  concat('insert into test.test123(id,name,name2) values(','replace(uuid(),''-'',''''),','replace(uuid(),''-'',''''),','replace(uuid(),''-'',''''));') t  from oper_log limit 10;
 

insert into test.test123(id,name,name2) values(replace(uuid(),'-',''),replace(uuid(),'-',''),replace(uuid(),'-',''));
insert into test.test123(id,name,name2) values(replace(uuid(),'-',''),replace(uuid(),'-',''),replace(uuid(),'-',''));
insert into test.test123(id,name,name2) values(replace(uuid(),'-',''),replace(uuid(),'-',''),replace(uuid(),'-',''));

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Mr.Z_z

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
使用sql批量生成mysql的insert语句

select concat('insert into test.test123(id,name,name2) values(','uuid(),','uuid(),','uuid())') t from oper_log limit 10;select concat('insert into test.test123(id,name,name2) values(','replace(uuid(),''-'',''''),','replace(uuid(),''-'',''''),','repla.
复制链接

扫一扫