Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Cebu City
    Posts
    9

    database migration

    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?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: database migration

    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •