MySQL Forums
Forum List  »  Microsoft Access

acces to mysql
Posted by: mbertschmann
Date: October 12, 2005 01:15AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
acces to mysql
2626
October 12, 2005 01:15AM
2196
October 12, 2005 02:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.