How to write the command for sql to insert a record

This article will explain in detail how to write the command about inserting records in sql. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The command for sql to insert a record is INSERT INTO.

Syntax 1: add full fields

INSERT INTO table name VALUES (value 1, value 2, etc.)

List with a simple student table: students have two columns: name (name) and age (age).

Insert Zhang San's information

INSERT INTO student VALUES (Zhang San, 18)

Display the result, Zhang San has been in the data student table

Syntax 2: specify that columns are added (empty columns are not allowed to be given values, otherwise they cannot be inserted) INSERT INTO table_name (column 1, column 2.) VALUES (value 1, value 2pm.)

Insert Li Si's information

INSERT INTO student (NAME) VALUES ('Li Si')

Show the data of student. Zhang San and Li Si are in the table.

This is the end of this article on "how to write the command to insert records 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.