FUDforum: comp.lang.php » Copying data between databases

Home » Imported messages » comp.lang.php » Copying data between databases

Show: Today's Messages :: Polls :: Message Navigator

Copying data between databases [message #174777]

Thu, 07 July 2011 04:41

Sloan
Messages: 2
Registered: July 2011

Karma:

Junior Member

Hi all,

I'm a bit new to PHP, but have been programming in other languages for quite
a while. I'm pretty good a SQL, including MySQL.

Here's my question:

How do I connect to two databases (on the same server) to use an INSERT ....
ON DUPLICATE KEY UPDATE in PHP were the source table in one database, and
the destination table is in another?

I've written the SQL statement with explicit db.table.field references so I
think I can use mysql_query, but which link do I use, or how can I pass both
links?

Thanks in advance!

Sloan

Report message to a moderator

[Message index]

		Copying data between databases By: Sloan on Thu, 07 July 2011 04:41
		Re: Copying data between databases By: Mick Gurling on Thu, 07 July 2011 04:51
		Re: Copying data between databases By: Sloan on Thu, 07 July 2011 05:00
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 06:09
		Re: Copying data between databases By: The Natural Philosoph on Thu, 07 July 2011 04:56
		Re: Copying data between databases By: alvaro.NOSPAMTHANX on Thu, 07 July 2011 06:28

Previous Topic:	multi-page form
Next Topic:	Earn $24.00 per Sign-Up!...Get Paided on all FREE MEMBERS!....{Sign-Up FREE}

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 02:35:41 GMT 2024

Total time taken to generate the page: 0.03839 seconds