SQL复制一条记录 - kk Blog —— 通用基础

SQL复制一条记录

2022-10-01 21:46:00

https://www.cnblogs.com/max1995/p/15410169.html

1.格式如下

insert into tablename (字段名1,字段名2,...,字段名3) select 字段名1,字段名2,...,字段名3 from tablename where id=...

2.例子

insert into tb (a, b, c)  select  '20211015', b, c from tb where id=123;