I am new to this program and I need to get data from one database table "A" to another database table "B" which either tables (source and target) have different column names, example follows:
Database A Database B
Table Members Table Users
MKey UKey
FirstName First
LastName Last
DOB LastUpdate
City Date
As you can see, I ONLY need to copy the data from table "members" to table "users" and only certain columns from Members (FirstName -> First) and (LastName -> Last)
Is there a tutorial on how to do this? Instructions?
using latest version of HeidiSQL
Thanks
Copy to another table
Seems that the text got messed up. Here is a screenshot of the example:
http://screencast.com/t/KtVOTKLxSd
http://screencast.com/t/KtVOTKLxSd
Please login to leave a reply, or register at first.