INSERT INTO
INSERT INTO adds a new row to a table.
In this page:
Syntax
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);INSERT INTO
Name the columns and supply matching values: INSERT INTO t (a, b) VALUES (1, x). Omitted columns take their DEFAULT or NULL. Listing columns makes statements robust when the table changes. INSERT ... SELECT copies rows from a query.
Note:
Always list column names in INSERT statements.
Example: INSERT INTO
CREATE TABLE members (id INTEGER PRIMARY KEY, name TEXT NOT NULL, plan TEXT DEFAULT 'free', age INTEGER);
INSERT INTO members (id, name, age) VALUES (1, 'Ada', 36);
INSERT INTO members (id, name, plan) VALUES (2, 'Bob', 'pro');
SELECT * FROM members;
-- Output:
-- id | name | plan | age
-- 1 | Ada | free | 36
-- 2 | Bob | pro | NULLLogin to try C/C++/Java/PHP code in the editor
Related Topics
Common Mistakes
- Relying on column order without naming columns
- Wrong number of values
- Forgetting quotes around text
Chapter Summary
- INSERT INTO table (cols) VALUES (values)
- Omitted columns use defaults
- List the columns explicitly
- INSERT ... SELECT copies rows
🔒
Chapter Quiz — Complete all 7 topics to unlock
0/7 topics done
Complete these topics first: