Page 1 of 1

insert into several databases

Posted: Wed May 17, 2006 12:10 pm
by alexislalas
hey there.


i would like a user to register with only one form and have certain data inserted into 3 different databases.


i was thinking of having 3 sql querys for each insert, is that the way it is done?

Posted: Wed May 17, 2006 12:35 pm
by RobertGonzalez
Yes, I believe that you will have to use multiple queries.

Re: insert into several databases

Posted: Wed May 17, 2006 4:16 pm
by raghavan20
alexislalas wrote:hey there.


i would like a user to register with only one form and have certain data inserted into 3 different databases.


i was thinking of having 3 sql querys for each insert, is that the way it is done?
unless they are all same DBs and can have a replication.

else you can always have a 'on after insert' trigger to take the data to different DBs.