At 12:47 AM +0200 8/10/09, Ralph Deffke wrote:
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
Sounds like a problem waiting to happen.
Cheers,
tedd
--
---
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
"tedd" wrote in message
news:p06240801c6a4fe331...@[192.168.1.100]...
> At 8:17 PM +0200 8/9/09, Ralph Deffke wr
At 8:17 PM +0200 8/9/09, Ralph Deffke wrote:
Hi all,
I'm facing the fact that it seems that auto_increment fields in a table not
start at 1 like it was in earlier versions even if I install mySQL brand new
creating all tables new. it seems to me that auto_increments handling has
changed to older
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the field is defined "long unsigned unique
auto_increment", what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10722
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the is defined long unsigned unique
auto_increment, what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10721.
it seems li
ALTER TABLE T1 AUTO_INCREMENT=1;
It's likely that you dropped every record and expected the auto_increment to
reset.
Jerry Wilborn
jerrywilb...@gmail.com
On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke wrote:
> Hi all,
>
> I'm facing the fact that it seems that auto_increment fields in a table no
Hi all,
I'm facing the fact that it seems that auto_increment fields in a table not
start at 1 like it was in earlier versions even if I install mySQL brand new
creating all tables new. it seems to me that auto_increments handling has
changed to older version. is somebody out there who can give me
7 matches
Mail list logo
