RE: [PHP] Remove rows from a MySQL table?
| From: | Chris W. Parker | Date: | Thu, 24 Mar 2005 17:40:17 +0000 |
| Subject: | RE: [PHP] Remove rows from a MySQL table? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-211484@lists.php.net to get a copy of this message | ||
Phil Neeb <mailto:06prneeb@alma.edu>
on Thursday, March 24, 2005 9:35 AM said:
> Is it possible to remove a row(s) from a MySQL table? I looked through
> the PHP manual and didn't see anything about it.
Use the word "delete" instead of remove.
In any case you have to tell MySQL which records you want to delete.
DELETE FROM
table
WHERE columnA = 'valueA';
HTH,
Chris.