So sprach Graeme B. Davis am Tue, May 01, 2001 at 01:09:15PM -0400:
Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted
to get the last insert id from. What if you run a web site and you have 10
tables in a database, how can you tell what the last insert id of table 6
COk I was thinking that you had to tell LAST_INSERT_ID the table you
wanted
to get the last insert id from. What if you run a web site and you have
10
tables in a database, how can you tell what the last insert id of table 6
was?
As I understand it, LAST_INSERT_ID is connection based, not
Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted
to get the last insert id from. What if you run a web site and you have 10
tables in a database, how can you tell what the last insert id of table 6
was?
Thanks,
Graeme
Because you included a from clause, you got one
: LAST_INSERT_ID returning 3 rows?
Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted
to get the last insert id from. What if you run a web site and you have
10
tables in a database, how can you tell what the last insert id of table 6
was?
Thanks,
Graeme
Because you included
last_insert_id is a function. It will return a value for each row in the
table. You want to run:
select last_insert_id() as lid;
instead of selecting from a table.
-Original Message-
From: Graeme B. Davis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 3:17 PM
To: [EMAIL
Because you included a from clause, you got one line for each row
of 'outages'
Leave out the from outages
Graeme B. Davis wrote:
mysql INSERT INTO outages (status) VALUES ('Open');
mysql SELECT LAST_INSERT_ID() AS lid FROM outages;
+-+
| lid |
+-+
| 101 |
| 101 |
| 101 |