INSERT

语法描述

INSERT用于在表中插入新行。

语法结构

1. > INSERT INTO [db.]table [(c1, c2, c3)] VALUES (v11, v12, v13), (v21, v22, v23), ...

示例

1. > CREATE TABLE test(a int, b varchar(10));

3. > INSERT INTO test values(123, 'abc');

5. > SELECT * FROM test;
6. +------+---------+
7. |   a  |    b    |
8. +------+---------+
9. |  123 |   abc   |
10. +------+---------+