any method can be delete entire data from DB at once time?
b'cos when we setup DB, we need to delete testing data one by one from table, its quite waste time.
thank u for any reply.
In order of increasing severity:
DELETE * FROM tablename WHERE condition; DELETE * FROM tablename; DROP TABLE tablename; DROP DATABASE database_name;
Pick the one that suits your application.
To do the whole database would be just a couple lines of code with [man]mysql_list_tables[/man], issuing a truncate table statement through a loop.
thank for reply...
i just aware phpMyAdmin have a funtion can be empty entire data.
