1.3.2 SQL (deleting record , Deleting tables)

Question 1

What does the command DELETE do?

Answer 1

removes data from a database table.

DELETE FROM users
WHERE age < 18;
(deletes all users younger than 18 from the ‘users’ table)

DELETE FROM users
WHERE name=”John”;
(deletes a record where the name is John)

Question 2

what does the command DROP do?

Answer 2

it deletes tables from a database.

DROP TABLE users;
(deletes the ‘users’ table)