1--sql insert quest example
2INSERT INTO table_name (column1, column2, column3, ...)
3VALUES (value1, value2, value3, ...);
1Adds a new column to an existing table.
2Example: Adds a new column named ‘email_address’ to a table named
3‘users’.
4ALTER TABLE users
5ADD email_address varchar(255);
1Add new rows to a table.
2Example: Adds a new vehicle.
3INSERT INTO cars (make, model, mileage, year)
4VALUES ('Audi', 'A3', 30000, 2016);
1INSERT INTO name (...)
2VALUES (...)
3Used alongside the INSERT INTO keyword to add new values to a table.
4Example: Adds a new car to the cars table.
5INSERT INTO cars (name, model, year)
6VALUES ('Ford', 'Fiesta', 2010);