Hi, If you want this to run faster, you can use the 'truncate table' syntax as explained here:
http://www.mysql.com/doc/en/TRUNCATE.html Cheers, Andrew -----Original Message----- From: Roger [mailto:[EMAIL PROTECTED] Sent: Tuesday 10 June 2003 23:01 To: Fabio Bernardo Cc: [EMAIL PROTECTED] Subject: Re: empty a table Try: delete from 'tablename'; Around Tue,Jun 10 2003, at 06:32, Fabio Bernardo, wrote: > Hi there, Im a new user > Whats the statemant to empty a table... I mean > I dont wanna delete one or two rows ...and not drop the table, i just > wanna empty it... i tried something like: empty table, but it didnt > work... thanks a lot -- Roger [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
