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]
