Re: using one query to save data in 4 tables

2005-03-28 Thread Gabriel PREDA
from MySQL in your application... Gabriel PREDA www.amr.ro www.lgassociations.info - Original Message - From: "James Black" <[EMAIL PROTECTED]> To: Sent: Saturday, March 26, 2005 12:14 AM Subject: re: using one query to save data in 4 tables > -BEGIN PGP SIGNED MESSAGE- >

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

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 i