1--sql insert quest example
2INSERT INTO table_name (column1, column2, column3, ...)
3VALUES (value1, value2, value3, ...);
1INSERT INTO Customer (FirstName, LastName, City, Country, Phone)
2VALUES ('Craig', 'Smith', 'New York', 'USA', 1-01-993 2800)
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);
1INSERT INTO users (first_name, last_name, address, email)
2VALUES (‘Tester’, ‘Jester’, ‘123 Fake Street, Sheffield, United
3Kingdom’, ‘test@lukeharrison.dev’);