If you would like to delete records from a MySQL table you can use one of the following options:
DELETE FROM ‘TABLE NAME’
DELETE FROM takes every row and then deletes the record if it matches a certain parameter. To delete all rows you could try DELETE * FROM ‘TABLE NAME’
TRUNCATE TABLE ‘TABLE NAME’
TRUNCATE TABLE is used as a more rigorous option to delete all records ad once. Not checking each row.
Which is to Use?
So if you are looking for a way to dele all rows from a MySQL table use TRUNCATE. Do you have to select specific rows to be deleted use DELETE FROM.
Hope this was helpful!
