I don't know if this is just weirdness on my system but I thought I would pass this on in case anyone runs into this problem. I'm converting some Java/JDBC code from a commercial DBMS to MySQL. The existing code executed the SQL statement "Select @@identity" after an INSERT to retrieve the autoincrement value. But, MySQL would never return from this query -- just hang until I stopped and restarted the service.
After some trial-and-error-and-error, I found that "@@IDENTITY" worked as expected but "@@identity" would cause this "hang" symptom. Moral of the story: don't use lower case letters in "SELECT @@IDENTITY". Rick --------------------------------------------------------------------- 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
