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 !
Georgia Tech Station 32003
Atlanta GA 30332
"I'm MySQL certified. Are you?"
From: Casey Sheridan [mailto:casey@stripped]
Sent: Thursday, March 18, 2004 6:32 PM
Subject: writing queries to get distinct results
I have a table that has employee names, pay rates, and unique IDs. I
to select all of the distinct employee names, and if there are two
with the same name, I want to be able to choose only one; the one with
highest pay rate. If there are two identical employee names with the
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!
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1