SQL INSERT Into - School4Tech

last tutorial, we created CAR table, now lets insert value into CAR table .

SQL insert Into is used to insert the value into tables. Below is the syntax:

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

1 2	INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

example:

INSERT INTO cars (id, model, color, manufacturer_id)
VALUES (1, 'Mustang', 'red', 1);

1 2	INSERT INTO cars (id, model, color, manufacturer_id) VALUES (1, 'Mustang', 'red', 1);

it will create one row in CAR table