T Sql 简明教程

T-SQL - INSERT Statement

SQL Server INSERT INTO 语句用于在数据库中的表中添加新数据行。

The SQL Server INSERT INTO statement is used to add new rows of data to a table in the database.

Syntax

以下是 INSERT INTO 语句的两个基本语法：

Following are the two basic syntaxes of INSERT INTO statement.

INSERT INTO TABLE_NAME [(column1, column2, column3,...columnN)]
VALUES (value1, value2, value3,...valueN);

其中，column1、column2、……columnN 是要在其中插入数据的表中的列名。

Where column1, column2,…columnN are the names of the columns in the table into which you want to insert data.

如果你为表的所有列添加值，则不需要在 SQL 查询中指定列名。但确保值的顺序与表中的列相同。以下是 SQL INSERT INTO 语法 −

You need not specify the column(s) name in the SQL query if you are adding values for all the columns of the table. But make sure the order of the values is in the same order as the columns in the table. Following is the SQL INSERT INTO syntax −

INSERT INTO TABLE_NAME VALUES (value1,value2,value3,...valueN);

Example

以下语句将在 CUSTOMERS 表中创建六条记录 −

Following statements will create six records in CUSTOMERS table −

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (2, 'Khilan', 25, 'Delhi', 1500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (3, 'kaushik', 23, 'Kota', 2000.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (4, 'Chaitali', 25, 'Mumbai', 6500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (5, 'Hardik', 27, 'Bhopal', 8500.00 );

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (6, 'Komal', 22, 'MP', 4500.00 );

Syntax

你可以使用第二个语法在 CUSTOMERS 表中创建记录，如下所示 −

You can create a record in CUSTOMERS table using second syntax as follows −

INSERT INTO CUSTOMERS VALUES (7, 'Muffy', 24, 'Indore', 10000.00 );

上面的所有语句都将在 CUSTOMERS 表中生成以下记录−

All the above statements will produce the following records in CUSTOMERS table −

ID  NAME       AGE         ADDRESS              SALARY
1   Ramesh     32          Ahmedabad            2000.00
2   Khilan     25          Delhi                1500.00
3   kaushik    23          Kota                 2000.00
4   Chaitali   25          Mumbai               6500.00
5   Hardik     27          Bhopal               8500.00
6   Komal      22          MP                   4500.00
7   Muffy      24          Indore               10000.00

Populate One Table Using Another Table

您可以通过在另一张表上 SELECT 语句来填充表中的数据，前提是另一张表有一组字段，需要先填充第一张表。以下是语法−

You can populate data into a table through SELECT statement over another table provided another table has a set of fields, which are required to populate first table. Following is the syntax −

INSERT INTO first_table_name
   SELECT column1, column2, ...columnN
      FROM second_table_name
      [WHERE condition];