Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "introduction to the use and difference of insert into select and select into in mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Insert into... Select.: all or part of the data in Table 1 can be copied to Table 2.

Eg: the copy code is as follows: insert into T2 (id,name,pwd) select id,name,pwd from T1

Note: T2 must exist. The column name queried in T1 may not be the same as the T1 column name. No values select...into: query the data in T1 and insert it into T2.

Eg: copy the code as follows: select * into T2 from T1

Note: T2 is created and populated with data.

This is the end of the introduction to the use and difference between insert into select and select into in mysql. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.