Question

Sing your knowledge of the employees table, what would be the result of the following statement:

DELETE FROM employees;

a. Nothing, no data will be changed.
b. All rows in the employees table will be deleted if there are no constraints on the table.
c. The first row in the employees table will be deleted.
d. Deletes employee number 100.

Answer 1

b. All rows in the employees table will be deleted if there are no constraints on the table.

Step-by-step explanation:

This is a MySql command.

DELETE FROM table_name [WHERE Clause]

If the where clause is not estabilished, as it happens in this example, the entire table will be deleted. The where clause is the constraint, that is, whichever row you want to delete.

The correct answer is:

b. All rows in the employees table will be deleted if there are no constraints on the table.