Back to lesson
1. What does the DELETE FROM Statement allow us to do?
Change our table.
Delete our Database.
Remove specific data from our table using SQL.
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