Re: How to delete all rows....

2006-09-25 Thread Chris
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 f

Re: How to delete all rows....

2006-09-25 Thread mos
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. The

Re: How to delete all rows....

2006-09-25 Thread Chris
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 lis

Re: How to delete all rows....

2006-09-22 Thread Dilipkumar
Sent: Wednesday, 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,

Re: How to delete all rows....

2006-09-20 Thread Chris
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 star

RE: How to delete all rows....

2006-09-20 Thread Peter Lauri
2006 2:56 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 To: mysql@lists.mysql.com Subject: How to delete all row

Re: How to delete all rows....

2006-09-20 Thread Chris
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:

RE: How to delete all rows....

2006-09-20 Thread Chandru, Pradeep
[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 To

Re: How to delete all rows....

2006-09-20 Thread Wagner, Chris (GEAE, CBTS)
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

RE: How to delete all rows....

2006-09-20 Thread cknipe
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

Re: How to delete all rows....

2006-09-20 Thread Douglas Sims
n Sep 20, 2006, at 2:55 AM, Peter Lauri wrote: 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

RE: How to delete all rows....

2006-09-20 Thread Peter Lauri
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

Re: How to delete all rows....

2006-09-19 Thread Praj
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 informat

Re: How to delete all rows....

2006-09-19 Thread Dan Trainor
[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: h

How to delete all rows....

2006-09-19 Thread ravi.karatagi
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 information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contai