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