Try TRUNCATE TABLE tablename-->http://www.mysql.com/doc/en/TRUNCATE.html Or DELETE FROM tablename
Regards, Mike Hillyer www.vbmysql.com -----Original Message----- From: Fabio Bernardo [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:33 PM To: Mysql (E-mail) Subject: empty a table 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
