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,
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 tabl
http://www.mysql.com/truncate
- Rich
From: Fabio Bernardo <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Subject: empty a table
Date: Tue, 10 Jun 2003 18:32:57 -0300
Hi there, Im a new user
Whats the statemant to empty a table... I mean
I dont wanna delete one or two rows ..
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
