Hi.
I have a number of tables with autoincrement colums
defined as:
CREATE TABLE HYPERLINK
( ID INT AUTO_INCREMENT NOT NULL ,
URL VARCHAR(255),
PRIMARY KEY(ID)
)
following an insert e.g.
Insert into Hyperlink (URL)
VALUES('http:\\www.yahoo.com')
I have queried with the following statement:
select last_insert_id()
which returns 0 which is not what I would have
expected.
I am doing this using mySQlGui 1.7.5-2 on Win 2000
Professional.
Grateful for any advice.
Best Wishes
Richard
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
