Adding a row

INSERT INTO table (columns) VALUES (values), in the same order.

Hone is a place to practise programming. This is one of its lessons, written out in full and free to read without an account.

What it is for

Every form submission and import ends here.

Which columns, in which order? Always list the columns. A table gains a column later and the unlisted INSERT breaks.

INSERT INTO films (title, year, minutes)

Named columns.

VALUES ('Arrival', 2016, 116);

Same order.

Insert a director.

INSERT INTO directors (name)  ('Villeneuve');

Quoting numbers or not quoting text. SQLite is lenient; most databases are not.

Practise INSERT on HoneA question on it now, a coding challenge where there is one, and it is remembered for review. Free, no email needed.