Shulou(Shulou.com)06/03 Report--

This article mainly introduces how to use sql statement to copy one or more records, which has certain reference value. Interested friends can refer to it. I hope you will gain a lot after reading this article. Let Xiaobian take you to understand it together.

insert into article (id,class,title,content) select id,'2',title,content from article where class='1'

If id is auto-numbered, change it to:

insert into article (class,title,content) select '2',title,content from article where class='1'

If class is a numeric type, remove the single quotes.

Thank you for reading this article carefully. I hope that Xiaobian's article "How to copy one or more records using sql statements" will be helpful to everyone. At the same time, I hope that everyone will support you a lot and pay attention to the industry information channel. More relevant knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.