INSERT INTO multiple rows in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert multiple rows into the table.

SQL

INSERT INTO employees (name, age) VALUES [1];

Drag options to blanks, or click blank then click option'

A('Alice', 30); ('Bob', 25)

B('Alice', 30)

C('Alice', 30), ('Bob', 25)

D('Alice', 30) ('Bob', 25)

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons between rows instead of commas.

Not using parentheses around each row.

Trying to insert rows without separating them.

To insert multiple rows in one statement, list them separated by commas inside the VALUES clause.

2fill in blank

medium

Complete the code to insert three rows into the products table.

SQL

INSERT INTO products (product_name, price) VALUES [1];

Drag options to blanks, or click blank then click option'

A('Pen', 1.5), ('Notebook', 3.0), ('Eraser', 0.5)

B('Pen', 1.5); ('Notebook', 3.0); ('Eraser', 0.5)

C('Pen', 1.5) ('Notebook', 3.0) ('Eraser', 0.5)

D('Pen', 1.5)

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons instead of commas between rows.

Missing commas between rows.

Not enclosing each row in parentheses.

Multiple rows are inserted by listing each row in parentheses separated by commas inside VALUES.

3fill in blank

hard

Fix the error in the code to insert multiple rows correctly.

SQL

INSERT INTO orders (order_id, quantity) VALUES [1];

Drag options to blanks, or click blank then click option'

A(101, 2); (102, 5)

B(101, 2), (102, 5)

C(101, 2) (102, 5)

D101, 2, 102, 5

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons instead of commas.

Not enclosing rows in parentheses.

Listing values without grouping them as rows.

Rows must be enclosed in parentheses and separated by commas inside VALUES.

4fill in blank

hard

Fill both blanks to insert two rows with columns id and score.

SQL

INSERT INTO results (id, score) VALUES [1] [2];

Drag options to blanks, or click blank then click option'

A(1, 90),

B(1, 90);

C(2, 85)

D(2, 85);

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons between rows.

Missing commas between rows.

Not enclosing rows in parentheses.

Separate multiple rows with commas inside VALUES. Semicolons end the statement and should not be used between rows.

5fill in blank

hard

Fill all three blanks to insert three rows into the table users with columns username and email.

SQL

INSERT INTO users (username, email) VALUES [1] [2] [3];

Drag options to blanks, or click blank then click option'

A('john', '[e-mail]'),

B('jane', '[e-mail]'),

C('doe', '[e-mail]')

D('jack', '[e-mail]')

Attempts:

3 left

💡 Hint

Common Mistakes

Adding a comma after the last row.

Using semicolons between rows.

Not enclosing rows in parentheses.

Multiple rows are listed inside VALUES separated by commas. The last row does not have a trailing comma.

Practice

1. What does the SQL statement INSERT INTO table_name (col1, col2) VALUES (1, 'A'), (2, 'B'); do?

easy

A. Deletes rows where col1 is 1 or 2.

B. Updates existing rows with new values.

C. Inserts two new rows into the table with specified values.

D. Creates a new table named table_name.

Solution

1. Step 1: Understand the INSERT INTO syntax

   The statement specifies columns and multiple sets of values separated by commas.

2. Step 2: Recognize the effect of multiple value sets

   Each set of values adds one new row to the table.

3. Final Answer:

   Inserts two new rows into the table with specified values. -> Option C

4. Quick Check:

   Multiple VALUES sets = multiple rows inserted [OK]

Hint: Multiple VALUES sets add multiple rows at once [OK]

Common Mistakes:

• Thinking it updates rows instead of inserting
• Confusing INSERT with DELETE or UPDATE
• Believing it creates a new table

2. Which of the following is the correct syntax to insert multiple rows into a table named students with columns id and name?

easy

A. INSERT INTO students (id, name) SET (1, 'Alice'), (2, 'Bob');

B. INSERT INTO students (id, name) VALUES (1, 'Alice'), (2, 'Bob');

C. INSERT INTO students (id, name) VALUES (1, 'Alice') AND (2, 'Bob');

D. INSERT INTO students VALUES (1, 'Alice'); (2, 'Bob');

Solution

1. Step 1: Check the correct use of VALUES keyword

   VALUES keyword must be followed by multiple sets of values separated by commas.

2. Step 2: Identify correct punctuation and keywords

   INSERT INTO students (id, name) VALUES (1, 'Alice'), (2, 'Bob'); uses commas correctly and no extra keywords like AND or SET.

3. Final Answer:

   INSERT INTO students (id, name) VALUES (1, 'Alice'), (2, 'Bob'); -> Option B

4. Quick Check:

   VALUES + comma-separated tuples = correct syntax [OK]

Hint: Use VALUES with comma-separated rows, no AND or SET [OK]

Common Mistakes:

• Using semicolons between value sets
• Using AND instead of commas
• Using SET keyword incorrectly

3. Given the table products(id INT, name VARCHAR(20)), what will be the result of this query?

INSERT INTO products (id, name) VALUES (1, 'Pen'), (2, 'Pencil'), (3, 'Eraser');
SELECT * FROM products;

medium

A. No rows will be added because SELECT does not insert data.

B. Only one row with id 3 and name Eraser will be added.

C. The query will cause a syntax error.

D. Three new rows with ids 1, 2, 3 and names Pen, Pencil, Eraser will be added.

Solution

1. Step 1: Analyze the INSERT statement

   The INSERT adds three rows with given ids and names in one command.

2. Step 2: Understand the SELECT statement

   SELECT * FROM products will show all rows including the newly inserted ones.

3. Final Answer:

   Three new rows with ids 1, 2, 3 and names Pen, Pencil, Eraser will be added. -> Option D

4. Quick Check:

   Multiple VALUES sets insert multiple rows [OK]

Hint: INSERT adds all rows; SELECT shows them all [OK]

Common Mistakes:

• Thinking only last row inserts
• Confusing SELECT with INSERT
• Expecting syntax error due to multiple rows

4. Identify the error in this SQL statement:

INSERT INTO employees (id, name) VALUES (1, 'John'); (2, 'Jane');

medium

A. Using semicolon between value sets causes syntax error.

B. Missing column names in the statement.

C. VALUES keyword is missing.

D. Using single quotes around names is invalid.

Solution

1. Step 1: Check punctuation between value sets

   Multiple rows must be separated by commas, not semicolons.

2. Step 2: Confirm correct use of VALUES and quotes

   VALUES keyword is present and single quotes for strings are correct.

3. Final Answer:

   Using semicolon between value sets causes syntax error. -> Option A

4. Quick Check:

   Use commas, not semicolons, between multiple VALUES [OK]

Hint: Separate multiple rows with commas, not semicolons [OK]

Common Mistakes:

• Using semicolons instead of commas
• Omitting column list when required
• Misusing quotes around strings

5. You want to insert multiple rows into a table orders(order_id, product, quantity) but only have values for product and quantity. Which query correctly inserts three rows with products and quantities, letting order_id auto-increment?

hard

A. INSERT INTO orders (product, quantity) VALUES ('Book', 2), ('Pen', 5), ('Notebook', 3);

B. INSERT INTO orders VALUES ('Book', 2), ('Pen', 5), ('Notebook', 3);

C. INSERT INTO orders (order_id, product, quantity) VALUES (NULL, 'Book', 2), ('Pen', 5), ('Notebook', 3);

D. INSERT INTO orders (product, quantity) VALUES ('Book', 2); ('Pen', 5); ('Notebook', 3);

Solution

1. Step 1: Use column list excluding auto-increment column

   Specify only product and quantity columns to let order_id auto-fill.

2. Step 2: Provide multiple value sets separated by commas

   INSERT INTO orders (product, quantity) VALUES ('Book', 2), ('Pen', 5), ('Notebook', 3); correctly uses VALUES with comma-separated tuples.

3. Final Answer:

   INSERT INTO orders (product, quantity) VALUES ('Book', 2), ('Pen', 5), ('Notebook', 3); -> Option A

4. Quick Check:

   Omit auto-increment column, list others, use commas [OK]

Hint: List columns except auto-increment, separate rows with commas [OK]

Common Mistakes:

• Omitting column list when not providing all columns
• Using semicolons between rows
• Inserting NULL explicitly for auto-increment column