my problem involves migrating data from 2 databases but with different tables and fields. for example, database1 has a table named EMPLOYEES with a field named fname while database2 has a table named PERSONS with a field name firstName. i would like to transfer all info from EMPLOYEES.fname to PERSONS.firstName. is this possible with mysql?

If you want a mySQL-specific answer you should ask the question in the mySQL forum. The generic answer is:

insert into persons(firstname, col1, col2, col3)
select fname, col4, col5, col6 from employees;