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

This article mainly talks about "what are the differences between select into from and insert into select". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what are the differences between select into from and insert into select"?

Steps / methods

1. First of all, let's take a look at the insert into select statement, whose syntax form is: Insert into Table2 (field1,field2,...) Select value1,value2,... From Table1 .

2. The requirement here is that the Table2 must already exist. If it does not exist, the system will indicate that the object is invalid.

3. At the same time, because Table2 already exists, we are free to add content that meets the column type to Table2, including constants, perhaps through the following figure, you will find that the import of constants when the unusual phenomenon.

4. Next, let's talk about the select into from statement, which is in the form of SELECT vale1, value2 into Table2 from Table1.

5. What is required here is that MyTable1 does not exist, because when inserting, the system will automatically create MyTable1. If the MyTable1 has been created before, the system will prompt you that the table already exists.

6, because of this feature, it will bring us a lot of convenience, first of all, if I only want the ID column in the MyTable2 table, then I just need to select the ID column and add it to the new table.

7. If I want the Name column in MyTable2, I just need to select the Name column and add it to the new table.

At this point, I believe you have a deeper understanding of "what is the difference between select into from and insert into select". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue 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.