| Re: Copying data between databases [message #174780 is a reply to message #174778] |
Thu, 07 July 2011 05:00   |
Sloan
Messages: 2
Registered: July 2011
Karma:
|
Junior Member |
|
|
Hi Mick,
Thanks for a quick answer. I read a bit of his site, but it seems to be a
bit of overkill for what I need. I need to setup a cron task to update data
in a second DB, with some modifications, and set it up as a cron task.
Here's an example of the kind of SQL statement I'm talking about:
INSERT INTO `some_db_jml62`.`jos_jshopping_products_to_categories`
(
`product_id`, `category_id`, `product_ordering`
)
SELECT `product_id`, `category_id`, `product_ordering`
FROM `some_db_jml61`.`jos_jshopping_products_to_categories`
ON DUPLICATE KEY UPDATE
SET
`some_db_jml62`.`jos_jshopping_products_to_categories`.`product_id` =
`some_db_jml61`.`product_id`.`product_id`,
`some_db_jml62`.`jos_jshopping_products_to_categories`.`category_id` =
`some_db_jml61`.`product_id`.`category_id`,
`some_db_jml62`.`jos_jshopping_products_to_categories`.`product_ordering`
= `some_db_jml61`.`product_id`.`product_ordering`
Is this the right group to be asking, or is there a MySQL / PHP group?
Again, thanks for the quick reply!
"Mick Gurling" <nospam(at)myemail(dot)net> wrote in message
news:iv3e02$30v$2(at)dont-email(dot)me...
> http://www.tonymarston.net/php-mysql/databaseobjects.html
>
> Use his objects or read how he uses the database connections.
>
> Mick
>
> On Wed, 06 Jul 2011 23:41:57 -0500, Sloan wrote:
>
>> 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
>
>
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]