Even the last_insert_id() returns 0 is it coz the table type is INNODB
----- Original Message ----- From: "Jan Peuker" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 4:16 PM Subject: Re: @@IDENTITY > You are using M$-Syntax, in MySQL you should use: > SELECT last_insert_id() > http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html > > regards, > > jan > > > ----- Original Message ----- > From: Arul > To: MySQL > Sent: Friday, June 21, 2002 12:17 PM > Subject: @@IDENTITY > > > Hi > > I m using mysql 3.23.51 on win 2k > > Well..I have a user table where i have the userid column as primary key and > auto_increment column and name as varchar(25). > > I insert values in the table such as > > Insert into user (name) values ('AA'); > > Then When i do select @@Identity in the next time , it tells me as 0 > > Why is this happenning.. > > I need to get the last inserted value of the primary key ..right > > -Arul > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
