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
2003-01-11
Thread
INVALID - TESTING ONLY. IF YOU GET EMAIL WITH THIS ACCOUNT PLEASE REPLY TO [EMAIL PROTECTED] INSTEAD. OBVIOUSLY WE MADE A MISTAKE IF YOU ARE READING THIS
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/