acces to mysql

[mbertschmann]

Hi. I have two mysql tables (the first one was Access). I want to migrate the Data from table 1 into table 2 (both tables are now in mysql). So I have to customize some fields. How do I manage to do that with SQL.
Please help!

thanks in advance!

Here is my table1:

Cust_ID
company
department
firstname
lastname
title
address1
address2
city
postal_code
country_code
email
tel1
tel2
mobile
fax
Categories
kunden_betreuer
status_legacy
status_id
IT_partner
source
Branchencode

Here is my table 2(no changes here!):

id
deleted
date_entered
date_modified
modified_user_id
assigned_user_id
created_by
salutation
first_name
last_name
lead_source
title
department
reports_to_id
birthdate
do_not_call
phone_home
phone_mobile
phone_work
phone_other
phone_fax
email1
email2
assistant
assistant_phone
email_opt_out
primary_address_street
primary_address_city
primary_address_state
primary_address_postalcode
primary_address_country
alt_address_street
alt_address_city
alt_address_state
alt_address_postalcode
alt_address_country
description
portal_name
portal_active
portal_app
invalid_email