Re: why in procedure truncate table do not reset auto_increment?

x schrieb: thanks may you point out which chapter says? From manual I get the following answer agaist to my result(my server version 5.0.45), For |InnoDB| before version 5.0.3, |TRUNCATE TABLE| is mapped to |DELETE|, so there is no difference. Starting with MySQL 5.0.3, fast |TRUNCATE TABLE|

Re: why in procedure truncate table do not reset auto_increment?

http://dev.mysql.com/doc/refman/5.1/en/truncate.html Sebastian Mendel 写道: 过客 schrieb: [...] why in procedure TRUNCATE table demo do not reset auto_increment? is clearly written in the documentation, just read ... in short: auto_increment is used for primary key, primary keys could be

Re: why in procedure truncate table do not reset auto_increment?

Martijn Tonies schrieb: > >>>>>>> [...] why in procedure TRUNCATE table >>>>>>> demo do not reset auto_increment? >>>>>> is clearly written in the documentation, just read ... >>>>>> >>>>>> in s

Re: why in procedure truncate table do not reset auto_increment?

> >>>>> [...] why in procedure TRUNCATE table > >>>>> demo do not reset auto_increment? > >>>> is clearly written in the documentation, just read ... > >>>> > >>>> in short: > >>>> > >>>

Re: why in procedure truncate table do not reset auto_increment?

Martijn Tonies schrieb: >>>>> [...] why in procedure TRUNCATE table >>>>> demo do not reset auto_increment? >>>> is clearly written in the documentation, just read ... >>>> >>>> in short: >>>> >>>> auto_

Re: why in procedure truncate table do not reset auto_increment?

> >>> [...] why in procedure TRUNCATE table > >>> demo do not reset auto_increment? > >> is clearly written in the documentation, just read ... > >> > >> in short: > >> > >> auto_increment is used for primary key, primary key

Re: why in procedure truncate table do not reset auto_increment?

Martijn Tonies schrieb: >>> [...] why in procedure TRUNCATE table >>> demo do not reset auto_increment? >> is clearly written in the documentation, just read ... >> >> in short: >> >> auto_increment is used for primary key, primary keys co

Re: why in procedure truncate table do not reset auto_increment?

> > [...] why in procedure TRUNCATE table > > demo do not reset auto_increment? > > is clearly written in the documentation, just read ... > > in short: > > auto_increment is used for primary key, primary keys could be referenced > from another table, setting au

Re: why in procedure truncate table do not reset auto_increment?

过客 schrieb: > [...] why in procedure TRUNCATE table > demo do not reset auto_increment? is clearly written in the documentation, just read ... in short: auto_increment is used for primary key, primary keys could be referenced from another table, setting auto_increment back to 0 could l

why in procedure truncate table do not reset auto_increment?

begin TRUNCATE table demo; show table status like 'demo'; END// delimiter ; when call test() I got auto_increment=101, why in procedure TRUNCATE table demo do not reset auto_increment? any help much appreciate !

Re: reset auto_increment

Mike, set insert_id=1; > can the auto_increment value be reset back to '1' withou recreate the > entire table again ?? The table would be emptied first, but we would like > to reset the auto_increment value back to '1' without having to drop and > recreate the table, if possible. Regards

reset auto_increment

Hi, can the auto_increment value be reset back to '1' withou recreate the entire table again ?? The table would be emptied first, but we would like to reset the auto_increment value back to '1' without having to drop and recreate the table, if possible. MySQL version 4.0.15 Linux TIA -- Mike

reset auto_increment

I need to reset the auto_increment in a table full of data. I had a problem recently where some script was putting InvoiceID numbers into an auto_increment CustID column...I since fixed the problem and corrected the data but I now have a huge gap in my number sequence and I cant get auto_increment

Re: reset auto_increment

At 16:06 -0500 1/10/03, "INVALID - TESTING ONLY. IF YOU GET EMAIL WITH THIS ACCOUNT P wrote: I need to reset the auto_increment in a table full of data. I had a problem recently where some script was putting InvoiceID numbers into an auto_increment CustID column...I since fixed the problem and c

RE: Reset auto_increment

. -Original Message- From: Wei Gao [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:10 PM To: [EMAIL PROTECTED] Subject: Reset auto_increment Hi, As I am new to MySQL, perhaps this is a common question you have been asked. I have a field "Id" which using auto_increm

Reset auto_increment

Hi, As I am new to MySQL, perhaps this is a common question you have been asked. I have a field "Id" which using auto_increment. Now I want to reset the value of auto_increment, that is the "Id" starts form 1 and does not skip the number. I have spent a few hours to find a way, but all failed.

RE: Reset auto_increment

From: Wei Gao [mailto:[EMAIL PROTECTED]] >Sent: Thursday, February 07, 2002 2:10 PM >To: [EMAIL PROTECTED] >Subject: Reset auto_increment > > >Hi, >As I am new to MySQL, perhaps this is a common question you have been asked. > >I have a field "Id" which using au

RE: Reset auto_increment

. -Original Message- From: Wei Gao [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 2:10 PM To: [EMAIL PROTECTED] Subject: Reset auto_increment Hi, As I am new to MySQL, perhaps this is a common question you have been asked. I have a field "Id" which using auto_increm

Reset auto_increment

Hi, As I am new to MySQL, perhaps this is a common question you have been asked. I have a field "Id" which using auto_increment. Now I want to reset the value of auto_increment, that is the "Id" starts form 1 and does not skip the number. I have spent a few hours to find a way, but all failed.

RE: reset auto_increment?

At 3:15 PM -0400 9/17/01, Jay Fesco wrote: > > Can someone tell me how to reset a column's auto_increment starting point >> back to 0 in mysql ? >> >> Thanks >> >> Paul >> >According to Paul DuBois on page 169 of MySQL by New Riders (which you >should buy): > >ALTER TABLE t > DROP i, >

RE: reset auto_increment?

> Can someone tell me how to reset a column's auto_increment starting point > back to 0 in mysql ? > > Thanks > > Paul > According to Paul DuBois on page 169 of MySQL by New Riders (which you should buy): ALTER TABLE t DROP i, ADD i INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY Ja

reset auto_increment?

Can someone tell me how to reset a column's auto_increment starting point back to 0 in mysql ? Thanks Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/