List:General Discussion« Previous MessageNext Message »
From:Freddie Sorensen Date:March 19 2004 7:46am
Subject:AW: Migrating Access databases to MySQL
View as plain text  
Arjun

The free DBTools DBManager can import Access databases directly to MySQL :
http://www.dbtools.com.br/EN/dbmanagerpro.php

Freddie 

-----Ursprüngliche Nachricht-----
Von: Arjun Subramanian [mailto:arjun@stripped] 
Gesendet: Freitag, 19. März 2004 02:56
An: mysql@stripped
Betreff: Migrating Access databases to MySQL

Hello people ! I was hoping for some wisdom from the good folks on this list
about moving databases from access to MySQL.

I am aware of the brute force method of exporting in CSV format or tab
delimited formats and using mysqlimport to move the tables. 

1. I was wondering if there was a way to dump access databases in SQL
queries like the mysqldump utility does ?

2. When exporting tab delimited values from access and using mysqlimport
everything works fine except date columns. All the data moves except the
date field which shows up zero's I mysql after I use mysqlimport. Does
anyone have a clue on what might be happening?

3. Is there any way other than downloading some shareware third party
programs to transfer my databases from access to MySQL ?


I would appreciate any help at all. Thanks to everyone in advance !

Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
"I'm MySQL certified. Are you?"


-----Original Message-----
From: Casey Sheridan [mailto:casey@stripped]
Sent: Thursday, March 18, 2004 6:32 PM
To: mysql@stripped
Subject: writing queries to get distinct results

I have a table that has employee names, pay rates, and unique IDs.  I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate.  If there are two identical employee names with the same
pay rate, I want to select the one that has the lowest unique ID number.
Can anyone help me on how to write this query?   Thanks!
-Casey Sheridan
Casey@stripped




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Thread
writing queries to get distinct resultsCasey Sheridan19 Mar
  • Migrating Access databases to MySQLArjun Subramanian19 Mar
    • Re: Migrating Access databases to MySQLKaram Chand19 Mar
    • AW: Migrating Access databases to MySQLFreddie Sorensen19 Mar
    • Re: Migrating Access databases to MySQLMartijn Tonies19 Mar
  • Re: writing queries to get distinct resultsVictoria Reznichenko19 Mar
RE: Migrating Access databases to MySQLArjun Subramanian19 Mar
  • Re: Migrating Access databases to MySQLBob Ramsey19 Mar