INSERT INTO
Try it yourself →Inserts a row into the table.
Syntax
INSERT INTO table VALUES (...);
Description
Adds new row(s). You can separate multiple rows with commas.
Example
CREATE TABLE k(id INTEGER, name TEXT); INSERT INTO k VALUES (1, 'Alex'), (2, 'Linus'); SELECT COUNT(*) FROM k;
Expected output
2
When to use?
Inserting data.