Re: Big problem with autoincrementing

2003-06-23 Thread Victoria Reznichenko
"Fandango del Morro" <[EMAIL PROTECTED]> wrote: > > Hello, > I'm new in this list and I also a newbie with MySql. I have a big problem > with autoincrementing with an initial value. For example: > > use Database Business; > create Table Clients(Client_ID int not null primary key auto_increment=1

Re: Big problem with autoincrementing

2003-06-22 Thread Paul DuBois
't know what "hcp" is. Is that a typo? http://www.kitebird.com/mysql-perl/ is still the companion site, and it still works. Thanks Fandango From: Paul DuBois <[EMAIL PROTECTED]> To: "Fandango del Morro" <[EMAIL PROTECTED]>,[EMAIL PROTECTED] Subject: Re: Big problem

Re: Big problem with autoincrementing

2003-06-22 Thread Fandango del Morro
MySql. Also, if you are the author of this book, notice that the link hcp://www.kitebird.com/mysql-perl/ no longer works. What is the new web site compagnon for the book? Thanks Fandango From: Paul DuBois <[EMAIL PROTECTED]> To: "Fandango del Morro" <[EMAIL PROTECTED]>,[EMAI

RE: Big problem with autoincrementing

2003-06-22 Thread Jorge Cornejo
I believe you got the autoincrement = 10 from Oracle? It doesn't work here -Mensaje original- De: Paul DuBois [mailto:[EMAIL PROTECTED] Enviado el: Domingo, 22 de Junio de 2003 11:37 a.m. Para: Fandango del Morro; [EMAIL PROTECTED] Asunto: Re: Big problem with autoincrementing At

Re: Big problem with autoincrementing

2003-06-22 Thread Paul DuBois
At 7:35 + 6/22/03, Fandango del Morro wrote: Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name

Re: Big problem with autoincrementing

2003-06-22 Thread O'K Web Design
Hi First, auto increment is a column type. You set the column to add one to the highest value in that column. If you would like the records to start at 10, either enter you "first" record with the Client_ID value explicitly set at 10 or enter a dummy MySQL statement like "INSERT INTO Client