You will have to call the last_insert_id() function in order to obtain the
autoincrement value.
-Original Message-
From: dan orlic
To: [EMAIL PROTECTED]
Sent: 8/25/04 2:26 PM
Subject: autoincrement question
question:
I have an insert statement that has a null for the value of the
pr
Alec,
Friday, August 09, 2002, 2:01:10 PM, you wrote:
AC> If I insert a number, say X, of records using a single statement of the
AC> form
AC> INSERT INTO table VALUES (...), (...), ..., (...)
AC> then retrieve the LAST_INSERT_ID, say Y, is it reasonable to assume that
AC> the records will
Bill Adams wrote:
> Demirchyan Oganes-AOD098 wrote:
>
> > Hello everyone,
> >
> > I wanted to ask you 2 questions.
> >
> > 1. I have a table that has 2 columns, user_id,
> user_name.
> > User_id has been setup to a default value 1000
> and to AUTO_INCREMENT.
> >
> > When I insert a record, Inser
Demirchyan Oganes-AOD098 wrote:
> Hello everyone,
>
> I wanted to ask you 2 questions.
>
> 1. I have a table that has 2 columns, user_id, user_name.
> User_id has been setup to a default value 1000 and to AUTO_INCREMENT.
>
> When I insert a record, Insert Into User_Table (user_id,user_name) Value
