SQL INSERT Statement: Syntax and Examples for High School Students

📚 Quick Study Guide

• 🔑 The SQL INSERT statement adds new rows to a table.
• 📝 Basic Syntax: `INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);`
• 📌 If inserting values into all columns, you can omit the column names: `INSERT INTO table_name VALUES (value1, value2, ...);`
• 🧮 Make sure the order and data types of values match the column definitions.
• ✨ Strings should be enclosed in single quotes ('). Numbers are generally not.
• 🚀 Example: `INSERT INTO Students (StudentID, FirstName, LastName) VALUES (1, 'Alice', 'Smith');`

🧪 Practice Quiz

1. Which SQL statement is used to insert new data into a database table?
   1. SELECT
   2. UPDATE
   3. INSERT
   4. DELETE
2. What is the correct syntax for inserting data into all columns of a table named 'Customers'?
   1. INSERT INTO Customers (column1, column2) VALUES (value1, value2);
   2. INSERT INTO Customers VALUES (value1, value2);
   3. ADD Customers VALUES (value1, value2);
   4. INSERT VALUES INTO Customers (value1, value2);
3. Which part of the INSERT statement specifies the table to insert data into?
   1. VALUES
   2. INTO
   3. SET
   4. FROM
4. What should strings be enclosed in within an INSERT statement?
   1. Double quotes (")
   2. Single quotes (')
   3. Backticks (`)
   4. No quotes
5. Consider a table 'Products' with columns (ProductID, ProductName, Price). Which statement correctly inserts a new product?
   1. INSERT INTO Products (1, 'Laptop', 1200.00);
   2. INSERT INTO Products VALUES (1, 'Laptop', 1200.00);
   3. INSERT INTO Products ('1', 'Laptop', '1200.00');
   4. INSERT INTO Products (ProductID, ProductName, Price) VALUES (1, 'Laptop');
6. If you only want to insert data into specific columns, what must you include in the INSERT statement?
   1. WHERE clause
   2. Column names in parentheses
   3. ORDER BY clause
   4. GROUP BY clause
7. Which of the following is NOT a part of the INSERT statement?
   1. INTO
   2. VALUES
   3. UPDATE
   4. Table Name