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