RE: Getting the value of a row you just inserted
Here's the link to the on-line manual page that will help you. http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html -Original Message- From: Dan Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Getting the value of a row you just inserted Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of a row that was just inserted? I'm using PHP, I don't know if that makes a difference? Something like: INSERT INTO foo (bar) VALUES (bar); SELECT last_insert(id) FROM foo; Also, are there any problems with using this in an environment where you're forking processes? Thanks in advance, -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting the value of a row you just inserted
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 09 October 2003 06:06 pm, Dan Anderson wrote: : Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of : a row that was just inserted? I'm using PHP, I don't know if that makes : a difference? : : Something like: : : INSERT INTO foo (bar) VALUES (bar); : SELECT last_insert(id) FROM foo; : : Also, are there any problems with using this in an environment where : you're forking processes? : : Thanks in advance, : : -Dan In php you can use mysql_insert_id() to get the id of the auto_increment column. See http://www.php.net/manual/en/function.mysql-insert-id.php todd[1] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/hd7v9xvMmfxCaFkRAsoZAJ9eL5aQf0dCHwY/nFdH5vQIny0BrgCgrcI3 V64M7/8+BnyHjJLlzYvG1C4= =MFdB -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]