Import or Merge? Combining data

Asked Jun 10 '16 at 20:22

Active Jun 10 '16 at 20:22

Viewed 83 times

I have two MDB databases that I'm bringing into MySQL via phpMyAdmin, one was internal and one from my customer. Both DB's have the same structure and similar data.

I want to take the data from the ACCOUNTS table, AuditorCode column from my internal DB and insert it into the customer DB where the AcctDB = A and the AcctNo field match. In this first DB merge, I'm looking at 88 records that I want to update out of 4,000.

I've tried merges within phpMyAdmin and I've tried via uploading CSV and SQL files to no avail. Could use some help on both the best method and how to use phpMyAdmin for this.

asked Jun 10 '16 at 20:22

John Smutny

sorry, but stackoverflow is for coding questions. – low_rents Jun 10 '16 at 20:30
Yes, I understand that. I've been trying to use SQL to merge the data unsuccessfully. – John Smutny Jun 10 '16 at 20:39
A similar problem was here: http://stackoverflow.com/questions/3502269/how-to-insert-table-values-from-one-database-to-another-database – bujals Jun 10 '16 at 20:39
That thread makes sense for SQL Server, but in phpMyAdmin I can't get the right syntax. – John Smutny Jun 10 '16 at 22:03

Import or Merge? Combining data

0 Answers0