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