SQLite Insert 语句

INSERT INTO 插入行：指定列插入或全列插入，也可 INSERT INTO ... SELECT 批量灌入。

Beginner

Key PointsSQLite,INSERT,插入

讲解

INSERT INTO 插入行：指定列插入或全列插入，也可 INSERT INTO ... SELECT 批量灌入。

SQL

INSERT INTO company (id, name, age, country)
VALUES (1, 'Google', 25, 'US');

INSERT INTO company (name, age) VALUES ('淘宝', 20);

Output

-- 插入后
SELECT * FROM company;

INSERT INTO 插入行：指定列插入或全列插入，也可 INSERT INTO ... SELECT 批量灌入。

SQL

INSERT INTO company (id, name, age, country)
VALUES (1, 'Google', 25, 'US');

INSERT INTO company (name, age) VALUES ('淘宝', 20);

Output

-- 插入后
SELECT * FROM company;