3. Inserting data

SELECT * FROM customer;

INSERT INTO customer (name, address, city, state, zip)

VALUES ("Leon", "123 ABC Street", "City Hall", "SG", "88688");

INSERT INTO customer

VALUES ("6", "Leo", "123 BCD Street", "Raffles Place", "SG", "88788");

Creating Null values row

INSERT INTO customer DEFAULT VALUES;

Insert values from another Table

INSERT INTO customer (id, name, address, city, state, zip) SELECT id, name, address, city, state, zip FROM supplier;