Clear data in MySQL table with PHP?

Question

How do I clear all the entries from just one table in MySQL with PHP?

Answer 1

TRUNCATE TABLE mytable

Be careful with it though.

Answer 2

TRUNCATE TABLE tablename

or

DELETE FROM tablename

The first one is usually the better choice, as DELETE FROM is slow on InnoDB.

Actually, wasn't this already answered in your other question?

Answer 3

TRUNCATE TABLE table;

is the SQL command. In PHP, you'd use:

mysql_query('TRUNCATE TABLE table;');

Answer 4

TRUNCATE TABLE `table`

unless you need to preserve the current value of the AUTO_INCREMENT sequence, in which case you'd probably prefer

DELETE FROM `table`

though if the time of the operation matters, saving the AUTO_INCREMENT value, truncating the table, and then restoring the value using

ALTER TABLE `table` AUTO_INCREMENT = value

will happen a lot faster.

Answer 5

Actually I believe the MySQL optimizer carries out a TRUNCATE when you DELETE all rows.