> truncate table_name > does both in one statement. And even optimizes the table (frees up > unused disk space). However take care that you cannot rollback this DDL.
Wow. Learn something new every day! :p Thanks for the tip, Rudy! Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
