H2 Database 简明教程
H2 Database - Insert
SQL INSERT 语句用于将新行的数据添加到数据库中的表。
The SQL INSERT statement is used to add new rows of data to a table in the database.
Syntax
以下是 INSERT INTO 语句的基本语法。
Following is the basic syntax of INSERT INTO statement.
INSERT INTO tableName
{ [ ( columnName [,...] ) ]
{ VALUES
{ ( { DEFAULT | expression } [,...] ) } [,...] | [ DIRECT ] [ SORTED ] select } } |
{ SET { columnName = { DEFAULT | expression } } [,...] }
使用这个 INSERT 语句,我们可以往表中插入一条新记录或多行新记录。当使用 DIRECT 子句时,结果会直接影响目标表,没有任何中间步骤。然而,在为表的所有列添加值的同时,确保值的顺序与表中的列相同。
Using this INSERT statement, we can insert a new record or new rows into a table. When using DIRECT clause, the results are directly affected to the target table without any intermediate step. However, while adding values for all the columns of the table, make sure the order of the values is in the same order as the columns in the table.
Example
我们举一个例子,并尝试将以下给定的记录插入到 Customer 表中。
Let us take an example and try to insert the following given records into the Customer table.
ID |
Name |
Age |
Address |
Salary |
1 |
Ramesh |
32 |
Ahmedabad |
2000 |
2 |
Khilan |
25 |
Delhi |
1500 |
3 |
Kaushik |
23 |
Kota |
2000 |
4 |
Chaitail |
25 |
Mumbai |
6500 |
5 |
Hardik |
27 |
Bhopal |
8500 |
6 |
Komal |
22 |
MP |
4500 |
7 |
Muffy |
24 |
Indore |
10000 |
我们可以通过执行以下命令将所有给定的记录放入 customer 表中。
We can get all the given records into the customer table by executing the following commands.
INSERT INTO CUSTOMER VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000);
INSERT INTO CUSTOMER VALUES (2, 'Khilan', 25, 'Delhi', 1500);
INSERT INTO CUSTOMER VALUES (3, 'kaushik', 23, 'Kota', 2000);
INSERT INTO CUSTOMER VALUES (4, 'Chaitali', 25, 'Mumbai', 6500);
INSERT INTO CUSTOMER VALUES (5, 'Hardik', 27, 'Bhopal', 8500);
INSERT INTO CUSTOMER VALUES (6, 'Komal', 22, 'MP', 4500);
INSERT INTO CUSTOMER VALUES (7, 'Muffy', 24, 'Indore', 10000);