"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
'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
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
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
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
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