Hi people, how do i do to delete all data in one table in mysql? i searched in my books, but don't found one results.


Tanks.

Hi macromotion
use this syntax to delete all data from mysql table:

DELETE from table_name [WHERE conditions];

If you don't specify any conditions ALL THE DATA IN THE TABLE WILL BE DELETED

if you want to delete only some rows, you can user for example:

DELETE from employee_data
WHERE emp_id = 10;

Query OK, 1 row affected (0.00 sec)


Thanks
Regards
Mani_he

TRUNCATE TABLE `table_name`

hth,

-Snib - http://www.snibworks.com
Where will you be in 100 years?

Tanks boys.

Where? Send in the mortar troops, Alpha-2-7-4! It's an invasion! ... oh wait....

*crawls back into hole*