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
