09/12/2003 12:28
Para
<[EMAIL PROTECTED]>
cc
Asunto
RE: How can I dump and empty
a table?
Lets do this:
mysqldump -u user -p [database_name] [tablename] > ./thefilewhatyouwouldliketocreate.dmp
Check that file.
VAso
-Original Message-
From: [EMAIL PROTECTED] [mail
and empty a table?
Dear list:
I apologize post this question, but I`m newbie with MySQL.
I have a database called "tacacs", it has many tables and one of them is called
"accounting". This table has many data stored since 2 month ago and it is very big and
it increases fr
Dear list:
I apologize post this question, but
I`m newbie with MySQL.
I have a database called "tacacs",
it has many tables and one of them is called "accounting". This
table has many data stored since 2 month ago and it is very big and it
increases frequently everyday.
I`d like to know how can I
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
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
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 ta
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
