Deleting data

Finally, let's look at how you delete data from your table. Note that when you delete something from MySQL, it is deleted - gone, no more, etc. Unless you use transactions that aren't committed, there is no "undo" feature. This is inherent to all databases, not just MySQL.

Here is the most basic way to delete data from a table:

DELETE FROM usertable;

That will delete all rows from a table, in the say way "SELECT * FROM usertable" will select all rows from a table. DELETE takes both the WHERE and LIMIT clauses, allowing you to construct more complicated statements such as this one:

DELETE FROM usertable WHERE FirstName = 'Bill' LIMIT 3;

 

Want to learn PHP 7?

Hacking with PHP has been fully updated for PHP 7, and is now available as a downloadable PDF. Get over 1200 pages of hands-on PHP learning today!

If this was helpful, please take a moment to tell others about Hacking with PHP by tweeting about it!

Next chapter: MySQL for dummies >>

Previous chapter: Updating data

Jump to:

 

Home: Table of Contents

Copyright ©2015 Paul Hudson. Follow me: @twostraws.