I have 2 MySql dbs on 2 different servers.
I need 2 copy the data from one field in db1 and add it into a new field ind db2.
What is the easiest way to do this? Both tables have the same number of records.
In db1, tableoriginal let's say there's an int field named id and a field named copyme (varchar). The second database has a table called tablenew and has a field called first_table_id that mirrors the original table's id field and I just inserted a new field called pastemehere (varchar).
I need 2 copy the data from one field in db1 and add it into a new field ind db2.
What is the easiest way to do this? Both tables have the same number of records.
In db1, tableoriginal let's say there's an int field named id and a field named copyme (varchar). The second database has a table called tablenew and has a field called first_table_id that mirrors the original table's id field and I just inserted a new field called pastemehere (varchar).