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

This article will explain in detail how to use NSERT INTO sentences in SQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

SQL INSERT INTO statement

The INSERT INTO statement is used to insert a new row into the table, or you can specify the column in which you want to insert the data. The syntax is as follows:

INSERT INTO table name VALUES (value 1, value 2...) INSERT INTO table_name (column 1, column 2...) VALUES (value 1, value 2pm.)

"Persons" table:

LastName FirstName Address CityCarter Thomas Changan Street Beijing

Insert a new row

INSERT INTO Persons VALUES ("Gates", "Bill", "Xuanwumen 10", "Beijing")

Results:

LastName FirstName Address CityCarter Thomas Changan Street BeijingGates Bill Xuanwumen 10 Beijing

Insert data into the specified column

INSERT INTO Persons (LastName, Address) VALUES ("Wilson", "Champs-Elysees")

Results:

This is the end of the LastName FirstName Address CityCarter Thomas Changan Street BeijingGates Bill Xuanwumen 10 BeijingWilson Champs-Elysees article on "how to use NSERT INTO sentences in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.