Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CharlieSW10

    SQL query to move data from one database to another

    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...
  2. CharlieSW10

    SQL query to move data from one database to another

    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...
  3. CharlieSW10

    SQL query to move data from one database to another

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

    SQL query to move data from one database to another

    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...
  5. CharlieSW10

    SQL query to move data from one database to another

    Yes
  6. CharlieSW10

    SQL query to move data from one database to another

    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...
  7. CharlieSW10

    SQL query to move data from one database to another

    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...
  8. CharlieSW10

    Setting Word document name and path

    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
  9. CharlieSW10

    Setting Word document name and path from VB6

    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...
  10. CharlieSW10

    Setting Word document name and path

    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...

Part and Inventory Search

Back
Top