I stand corrected. My apologies tim.
Mark ----------------------------------------------------------------- [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Tim Lucas <[EMAIL PROTECTED]>: > > > > > >@@IDENTITY is NOT supported in mySQL. Tim got mistaken about which DB we > were talking > >about. In mySQL you use Last_INSERT_ID(). > > > @@identity has been a synonym for last_insert_id() since MySQL v3.23.25 > (released in 2000) > > For example try the following: > > CREATE TABLE testtable ( > `id` int(11) unsigned NOT NULL auto_increment, > PRIMARY KEY (`id`) > ) TYPE=MyISAM; > > INSERT INTO testtable () VALUES (); > SELECT @@identity; > INSERT INTO testtable () VALUES (); > SELECT @@identity; > > >(Use http://www.mysql.com/search/index.php?q=@@IDENTITY&from=%2Findex.html > if you > >doubt me) > > > See > http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.25 > > - tim > > Mark M spoke the following wise words on 12/02/2004 1:23 PM EST: > > >Just to be clear on 2 things > > > >1) > > > > > >>And thanks to Tim Lucas who recently brought to light the ability to use > >>@@IDENTITY in mySQL v4+. > >> > >> > > > >@@IDENTITY is NOT supported in mySQL. Tim got mistaken about which DB we > were talking > >about. In mySQL you use Last_INSERT_ID(). > >(Use http://www.mysql.com/search/index.php?q=@@IDENTITY&from=%2Findex.html > if you > >doubt me) > > > > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
