1
SQL复制一条记录
source link: http://abcdxyzk.github.io/blog/2022/10/01/mysql-si/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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=...insert into tb (a, b, c) select '20211015', b, c from tb where id=123;Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK