Search results for query: *

As you might have seen in the above post I have now got the synch working, using the SQL statement below: REPLACE INTO rtdtest.products ( ID, title, price, category, available) SELECT product.Product_Code, product.Product_Description, product.Price, product.Category_Name...

Works a treat - the relevant section is in the comments to the MySQL documentation: Using INSERT INTO ... SELECT you can copy data from one database to another. You need the correct privileges for both. Enter the source database, database1: use database1; Then write to which fields in the...

Thank you for the steer and the quick response, I'll try in now.

I forgot to mention that I'm hoping I can find an SQL statement that will do the job and then run it as a cron job every 10 minutes. What I'm actually doing is ensuring that product details held within an ECommerce shopping cart are kept in sync with the warehouse management system where new...

Yes

Thanks for your help, I did look at replication but from what I could make out it would not allow me to selectively pull out some columns from one table and write them into another table (in another database)which has a different structure. The fields I want to move from Database A to Database...

I am a newcomer to MySQL and am trying to work out how I can automate moving data from a table within one MySQL database to a table in another. I want to ensure that changes made to a table in Database A are reflected in Database B. I assume that the best way to do this would be to use the...

I've moved this question to the VB for Applications forum but would very much like to hear from you if you have any suggestions. Charlie

I am using the Word 9.0 Object Library and VB 6 to populate a template document with values from an Access form. The user can then edit the Word document to make any necessary changes before saving it to the directory where I want all these documents held. In most cases this works fine: First...

I am using the Word 9.0 Object Library and VB 6 to populate a template document with values from an Access form. The user can then edit the Word document to make any necessary changes before saving it to the directory where I want all these documents held. At the moment this works fine in most...