The DELETE statement allows you to delete data from a table. The table structure remains in the database. This command is often confused with DROP as it deletes data and the table structure from the database.
Structure:
DELETE FROM table_name;
Example1:
DELETE FROM Staff WHERE Staff_Name = 'Frank';
I give people clear, functional, and proven instructions. I gently guide them so that they can fulfill their IT dreams.