question:
I have an insert statement that has a null for the value of the
primary key, id, since that value is also a
auto-increment field. The problem i am running into is I need that Id
further down the road for map tables, but I have no idea
what the id is, since it is in fact,
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
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 be
If I insert a number, say X, of records using a single statement of the
form
INSERT INTO table VALUES (...), (...), ..., (...)
then retrieve the LAST_INSERT_ID, say Y, is it reasonable to assume that
the records will be numbered contiguously from Y-X+1 to Y, even in a
multi-user
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) Values (Null,'Jon
Doe');
I get 1 John Doe. But
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) Values
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, Insert Into User_Table