INSERT INTO single row in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SQL command INSERT INTO do?

It adds a new row of data into a table in the database.

beginner

Write the basic syntax to insert a single row into a table named users with columns name and age.

INSERT INTO users (name, age) VALUES ('Alice', 30);

intermediate

Can you insert a row without specifying column names? When is it allowed?

Yes, if you provide values for all columns in the exact order they appear in the table. Otherwise, you must specify column names.

intermediate

What happens if you try to insert a row with a missing value for a column that does not allow NULL?

The database will return an error because that column requires a value and cannot be empty.

beginner

Why is it a good idea to specify column names in an INSERT INTO statement?

It makes your query clearer and safer, especially if the table structure changes later. It also avoids mistakes with column order.

Which SQL keyword is used to add a single row to a table?

A UPDATE

B SELECT

C INSERT INTO

D DELETE

INSERT INTO is used to add new rows to a table.

What must you include in an INSERT INTO statement to add data correctly?

A Table name and values

B Only values

C Only table name

D Column names and values

You should include column names and their corresponding values to avoid errors.

What happens if you omit column names but provide fewer values than columns in the table?

A An error occurs

B The database guesses the columns

C The row is inserted with NULLs

D The row is inserted with default values

Omitting column names requires values for all columns. Otherwise, an error happens.

Which of these is a correct INSERT INTO statement for table products(id, name)?

A INSERT INTO products (id, name) VALUES (1, 'Pen');

B INSERT INTO products VALUES (1, 'Pen');

C INSERT products (id, name) VALUES (1, 'Pen');

D INSERT INTO products (name, id) VALUES ('Pen', 1);

Options A, B, and D are correct. Option C is missing "INTO".

Why might you get an error inserting a row with a missing value?

A Because the value is too large

B Because the column is set to NOT NULL

C Because the database is offline

D Because the table is empty

If a column is NOT NULL, it must have a value when inserting a row.

Explain how to insert a single row into a MySQL table and why specifying column names is important.

Think about matching data to the right place in the table.

What errors might occur when inserting a single row and how can you prevent them?

Consider the rules the database enforces on data.