Re: using one query to save data in 4 tables

2005-03-28 Thread Gabriel PREDA
www.lgassociations.info - Original Message - From: James Black [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, March 26, 2005 12:14 AM Subject: re: using one query to save data in 4 tables -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am curious if this would be possible, and which

Re: using one query to save data in 4 tables

2005-03-26 Thread Jigal van Hemert
From: James Black Basically, I want to store a user in one table, then get the id for the user I just saved, and store three more rows, each in a different database, using the user's id in the insert statements. I don't think it can be done with a single statement, but you actually don't need

re: using one query to save data in 4 tables

2005-03-25 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am curious if this would be possible, and which version of mysql would be needed. Basically, I want to store a user in one table, then get the id for the user I just saved, and store three more rows, each in a different database, using the user's