Back to lesson
1. What does the DELETE FROM Statement allow us to do?
Remove specific data from our table using SQL.
Delete our Database.
Change our table.
2. How do you delete all the data from your table?
Use DELETE FROM, just don't give it a where clause.
Use Delete From
3. What if you designate a First Name Like 'John' to Delete and there is more than one John in your table?
Just the first "John" will be deleted.
All Records with First Name John will be deleted.
No records will be deleted.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement