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
mysql INSERT INTO outages (status) VALUES ('Open');
mysql SELECT LAST_INSERT_ID() AS lid FROM outages;
+-+
| lid |
+-+
| 101 |
| 101 |
| 101 |
+-+
3 rows in set (0.00 sec)
Why would MYSQL do this? Any ideas?
Thanks,
Graeme
p.s. DESCRIBE outages;
PROTECTED]
Subject: LAST_INSERT_ID returning 3 rows?
mysql INSERT INTO outages (status) VALUES ('Open');
mysql SELECT LAST_INSERT_ID() AS lid FROM outages;
+-+
| lid |
+-+
| 101 |
| 101 |
| 101 |
+-+
3 rows in set (0.00 sec)
Why would MYSQL do this? Any ideas?
Thanks,
Graeme
p.s
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 |