On Wed, Jul 05, 2006 at 09:08:25AM +0800, Syan Tan wrote: > I am using selecting the max(demographic_no) to retrieve the > oscar_no, after inserting into the oscar demographic, There is some such thing as "last_inserted" which supposedly returns the last inserted PK "transaction-safe" in MySQL.
Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
