SQL
INSERT INTO
INSERT INTO table (columns) VALUES (values) adds a new
row.
Example: adding a new student
INSERT INTO students (name, track, score)
VALUES ('Ngozi', 'Frontend', 88);1 row inserted.The columns listed and the values listed must match up in the exact
same order, here, 'Ngozi' goes to name,
'Frontend' to track, 88 to
score. Notice id wasn't included at all, most
real tables auto-generate a new id for each inserted row, so you almost
never specify it yourself.
INSERT INTO students (name, track, score)
VALUES ('Ngozi', 'Frontend', 88);1 row inserted.