How to empty database table??

edhan · 10-23-2003, 10:44 PM

Hi

I have tried using the command under PHP to empty the database table, but it does not. Using phpMyAdmin, I am able to use the empty function to remove the data.

I have issued the command: "delete * from database.table" but it does nothing.

Please advice how can I empty the table without using the phpMyAdmin to empty the table.

Thanks!

Regards
Edward Han

druuna · 10-24-2003, 09:25 AM

Use truncate: TRUNCATE TABLE table_name

Truncate is also faster then delete.

This, and other cool things, can be found in the mysql documentation.

edhan · 10-24-2003, 08:53 PM

Hi druuna

Yes, it works! Thanks.

Regards
Edward Han