Hi Doug,
Try to use
insert into player_table(playerid, player_name) values (auto,
'$player_name);
Cheers,
Minh Dam
On Mon, 19 Feb 2001, Doug Linley wrote:
> I have a table that I created that has a primary key field that should be
> auto_incremented. To fill in this value I am calling
>
>
, another
client might already have used that value.
Regards
Quentin
-Original Message-
From: Doug Linley [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 20 February 2001 11:33
To: [EMAIL PROTECTED]
Subject: auto_increment and last_insert_value()
I have a table that I created that has a pr
On Mon, Feb 19, 2001 at 05:33:00PM -0500, Doug Linley wrote:
> I have a table that I created that has a primary key field that should be
> auto_incremented. To fill in this value I am calling
>
> insert into player_table(playerid, player_name) values (LAST_INSERT_ID() +
> 1, '$player_name');
>
AIL PROTECTED]]
Sent: Monday, February 19, 2001 4:33 PM
To: [EMAIL PROTECTED]
Subject: auto_increment and last_insert_value()
I have a table that I created that has a primary key field that should be
auto_incremented. To fill in this value I am calling
insert into player_table(playerid,
If playerid is an auto_increment field, then either of these work --
INSERT INTO player_table(player_name) VALUES ('$player_name');
INSERT INTO player_table(playerid, player_name) VALUES
(NULL,'$player_name');
"Doug Linley" <[EMAIL PROTECTED]> wrote:
I have a table that I created that has a
I have a table that I created that has a primary key field that should be
auto_incremented. To fill in this value I am calling
insert into player_table(playerid, player_name) values (LAST_INSERT_ID() +
1, '$player_name');
My problem is that I'm getting duplicated key values because last_insert_
