Re: How to delete all rows....

[Dan Trainor]

[EMAIL PROTECTED] wrote:

Hi All,

            How do I delete all the rows of all the tables(but not
table) in the database at one shot.




Regards,

Ravi K

Hi -

Please see http://dev.mysql.com/doc/refman/5.0/en/truncate.html

Thanks
-dant


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]