At 08:41 PM 9/25/2006, you wrote:
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?....
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to finish.
The drawback of truncate is it requires a table lock and if people are
updating the table, the truncate will have to wait for the locks to
complete. There is also RI to worry about.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]