INSERT INTO single row in SQL - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to insert a single row into the table named employees.

SQL

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

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

A'John', 30

B(John, 30)

CJohn, 30

D'John'

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put string values in quotes.

Not separating values with commas.

Including extra parentheses around values.

The VALUES clause requires the values for all columns specified, separated by commas and enclosed in parentheses. Here, 'John' is a string and 30 is a number, so the correct syntax is ('John', 30).

2fill in blank

medium

Complete the code to insert a single row with columns id and salary into the table payroll.

SQL

INSERT INTO payroll (id, salary) VALUES ([1]);

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

A'101', 5000

B101, '5000'

C(101, 5000)

D'101', '5000'

Attempts:

3 left

💡 Hint

Common Mistakes

Putting numbers inside quotes.

Mixing data types incorrectly.

Numeric values like id and salary should not be enclosed in quotes. So 101 and 5000 are correct without quotes, and they must be enclosed in parentheses.

3fill in blank

hard

Fix the error in the INSERT statement to add a row into the products table with columns product_name and price.

SQL

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

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

A('Laptop'; 1200)

B('Laptop', 1200)

CLaptop, 1200

D['Laptop', 1200]

Attempts:

3 left

💡 Hint

Common Mistakes

Using semicolons instead of commas.

Not using parentheses around values.

Using square brackets instead of parentheses.

The VALUES clause must have parentheses around the values separated by commas. Using semicolons or brackets is incorrect syntax.

4fill in blank

hard

Fill both blanks to insert a row into the table orders with columns order_id and customer_name.

SQL

INSERT INTO orders ([1], [2]) VALUES (102, 'Alice');

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

Aorder_id

Bcustomer_id

Ccustomer_name

Dorder_date

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong column names that don't match values.

Mixing up customer_id and customer_name.

The columns to insert into must match the values. Here, 102 is the order_id and 'Alice' is the customer_name.

5fill in blank

hard

Fill all three blanks to insert a row into the table students with columns student_id, name, and grade.

SQL

INSERT INTO students ([1], [2], [3]) VALUES (201, 'Emma', 'A');

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

Astudent_id

Bname

Cgrade

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Including columns not in the values list.

Wrong order of columns causing mismatch.

The column names must correspond to the values in order: student_id = 201, name = 'Emma', grade = 'A'.

Practice

1. What does the SQL statement INSERT INTO students (name, age) VALUES ('Alice', 20); do?

easy

A. Deletes the student named Alice from the students table.

B. Adds a new student named Alice aged 20 to the students table.

C. Updates the age of all students to 20.

D. Creates a new table named students with columns name and age.

Solution

1. Step 1: Understand the INSERT INTO statement

   The statement adds data to an existing table by specifying columns and values.

2. Step 2: Match columns and values

   The columns are name and age, and the values are 'Alice' and 20, so a new row is added with these values.

3. Final Answer:

   Adds a new student named Alice aged 20 to the students table. -> Option B

4. Quick Check:

   INSERT INTO adds one row [OK]

Hint: INSERT INTO adds one row with matching columns and values [OK]

Common Mistakes:

• Confusing INSERT with DELETE or UPDATE
• Not matching columns and values order
• Using wrong quotes for text values

2. Which of the following is the correct syntax to insert a single row into the table employees with columns id and name?

easy

A. INSERT employees (id, name) VALUES (1, 'John');

B. INSERT INTO employees (id, name) SET (1, 'John');

C. INSERT INTO employees VALUES id=1, name='John';

D. INSERT INTO employees (id, name) VALUES (1, 'John');

Solution

1. Step 1: Recall correct INSERT syntax

   The correct syntax requires the keywords INSERT INTO, table name, columns in parentheses, then VALUES with matching values.

2. Step 2: Check each option

   INSERT INTO employees (id, name) VALUES (1, 'John'); matches the correct syntax exactly; others have missing INTO, wrong assignment, or SET keyword which is invalid here.

3. Final Answer:

   INSERT INTO employees (id, name) VALUES (1, 'John'); -> Option D

4. Quick Check:

   INSERT INTO ... VALUES (...) is correct syntax [OK]

Hint: Always use INSERT INTO table (columns) VALUES (values) [OK]

Common Mistakes:

• Omitting INTO keyword
• Using SET instead of VALUES
• Incorrect assignment inside VALUES

3. Given the table products with columns product_id (integer) and product_name (text), what will be the result of this query?

INSERT INTO products (product_id, product_name) VALUES (101, 'Pen');

medium

A. A new row with product_id 101 and product_name 'Pen' is added to products.

B. The query returns an error because product_name is text and needs double quotes.

C. The query updates product_id 101 to have product_name 'Pen'.

D. No change happens because INSERT INTO requires multiple rows.

Solution

1. Step 1: Understand the INSERT INTO effect

   The query adds one new row with specified values to the products table.

2. Step 2: Check syntax and data types

   Text values use single quotes in SQL, so 'Pen' is correct. No error occurs.

3. Final Answer:

   A new row with product_id 101 and product_name 'Pen' is added to products. -> Option A

4. Quick Check:

   INSERT INTO adds one row with given values [OK]

Hint: Text values need single quotes; INSERT adds one row [OK]

Common Mistakes:

• Using double quotes for text values
• Thinking INSERT updates existing rows
• Believing INSERT requires multiple rows

4. Identify the error in this SQL statement:

INSERT INTO orders (order_id, customer) VALUES (123, John);

medium

A. The table name orders is invalid.

B. Missing parentheses around the VALUES keyword.

C. Missing single quotes around the text value John.

D. Using double quotes instead of single quotes for John.

Solution

1. Step 1: Check the VALUES clause

   The value John is a text string and must be enclosed in single quotes in SQL.

2. Step 2: Verify other syntax parts

   Parentheses around VALUES are correct; table name orders is valid; double quotes are not used here.

3. Final Answer:

   Missing single quotes around the text value John. -> Option C

4. Quick Check:

   Text values need single quotes [OK]

Hint: Text values must be in single quotes [OK]

Common Mistakes:

• Forgetting quotes around text
• Using double quotes instead of single
• Misplacing parentheses

5. You have a table users with columns id (integer), username (text), and email (text). Which SQL statement correctly inserts a new user with id 5, username 'maria', and email '[e-mail]'?

hard

A. INSERT INTO users (id, username, email) VALUES (5, 'maria', '[e-mail]');

B. INSERT INTO users VALUES (5, maria, [e-mail]);

C. INSERT INTO users (id, username, email) VALUES ('5', 'maria', [e-mail]);

D. INSERT INTO users (id, username, email) SET (5, 'maria', '[e-mail]');

Solution

1. Step 1: Match columns and values correctly

   The columns id, username, and email are listed, so values must be in the same order and properly quoted.

2. Step 2: Check value types and syntax

   Integer 5 does not need quotes, text values 'maria' and '[e-mail]' need single quotes. INSERT INTO users (id, username, email) VALUES (5, 'maria', '[e-mail]'); matches this exactly.

3. Final Answer:

   INSERT INTO users (id, username, email) VALUES (5, 'maria', '[e-mail]'); -> Option A

4. Quick Check:

   Match columns and values with correct quotes [OK]

Hint: Match columns and values; quote text, not numbers [OK]

Common Mistakes:

• Not quoting text values
• Using SET instead of VALUES
• Quoting integers unnecessarily