W3. SQL Insert Into

Question 1

Q: What is the purpose of the SQL INSERT INTO statement?

Answer 1

A: To insert new records into a table.

Question 2

Q: What is one way to write the INSERT INTO statement with specified columns?

Answer 2

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

Question 3

Q: How do you insert values into all columns without specifying column names?

Answer 3

INSERT INTO table_name 
VALUES (value1, value2, value3, ...);

(Ensure values are in the correct order.)

Question 4

Q: Write an example INSERT INTO statement that adds a record with specific column names in the “Customers” table.

Answer 4

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) 
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

Question 5

Q: What happens to an AUTO_INCREMENT column like CustomerID when a new record is inserted?

Answer 5

A: It is generated automatically without specifying a value for it.

Question 6

Q: Can you insert data into specific columns only? Provide an example.

Answer 6

A: Yes, by specifying only those columns.

INSERT INTO Customers (CustomerName, City, Country) 
VALUES ('Cardinal', 'Stavanger', 'Norway');

Question 7

Q: How do you insert multiple rows in a single INSERT INTO statement?

Answer 7

A: Use multiple sets of values, separated by commas.

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) 
VALUES 
('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway'),
('Greasy Burger', 'Per Olsen', 'Gateveien 15', 'Sandnes', '4306', 'Norway');

Question 8

Q: What must you do to separate multiple rows in a single INSERT INTO statement?

Answer 8

A: Separate each row of values with a comma.