Mike Kruckenberg wrote:
mysql> SET @staff_id = LAST_INSERT_ID(); Query OK, 0 rows affected (0.01 sec)
I don't know if this behaviour has changed in later versions of mysql, but using session variables, although lovely, was the quickest way to break replication (at least up to and including 4.0.27) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]