SQL INSERT Clause ¶

Insert a new record.

INSERT INTO client VALUES ('Luna', 18, 'Japan')

👉 You don't have to give a value to an "AUTO_INCREMENT" attribute.

You can also specify for which column you give a value. It's required when giving values in a different order than the table column order.

INSERT INTO client(name, age, country) VALUES ('Luna', 18, 'Japan')