mos wrote:
At 08:41 PM 9/25/2006, you wrote:
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to finish.
--
MySQL General Mailing List
For
At 08:41 PM 9/25/2006, you wrote:
Dilipkumar wrote:
Hi,
Its delete * from table will only do if you go for a truncate it will
recreate the table structure ?
It's better to use delete.
Can you explain why? I'd go for instant truncate rather than waiting
around for delete to finish.
, September 20, 2006 1:25 PM
Subject: RE: How to delete all rows
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows
Hi All,
How do
If its one time .. i will suggest to take a mysqldump of table structure
only and drop the database import the backup .
[EMAIL PROTECTED] wrote:
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
The
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows
Hi All,
How do I delete all the rows of all the tables(but not
table) in the
You might also look at TRUNCATE table...
http://dev.mysql.com/doc/refman/5.0/en/truncate.html
I believe that DELETE will not reclaim the storage space while
TRUNCATE does, although I didn't see that in the documentation when I
looked just now... ?
Douglas Sims
[EMAIL PROTECTED]
On Sep
FLUSH table ??
Quoting Peter Lauri [EMAIL PROTECTED]:
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows
Hi All,
But how will that interact with the auto increment counter? Will
truncate reset the counter.
Chris wrote:
Peter Lauri wrote:
DELETE FROM table
Truncate will be a lot better.
DELETE FROM table will do it row by row which also means it will have to
update any indexes applicable to the
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 1:26 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: How to delete all rows
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
Peter Lauri wrote:
DELETE FROM table
Truncate will be a lot better.
DELETE FROM table will do it row by row which also means it will have to
update any indexes applicable to the table as it goes...
Lots of data lots of indexes = very slow.
--
MySQL General Mailing List
For list archives:
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: How to delete all rows
DELETE FROM table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 10:35 AM
To: mysql@lists.mysql.com
Subject: How to delete all rows
Hi All
Wagner, Chris (GEAE, CBTS) wrote:
But how will that interact with the auto increment counter? Will
truncate reset the counter.
According to the docs it will:
http://dev.mysql.com/doc/refman/5.1/en/truncate.html
The table handler does not remember the last used AUTO_INCREMENT value,
but
[EMAIL PROTECTED] wrote:
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
Hi -
Please see http://dev.mysql.com/doc/refman/5.0/en/truncate.html
Thanks
-dant
--
MySQL General Mailing List
For list archives:
14 matches
Mail list logo