I have > 200 tables with regular datetime fields. I link these tables
through ODBC to an ACCESS database where I can run standard ACCESS append
queries or even copy/paste append into the linked table. ODBC handles the
conversion just fine.
One caution, MySQL timestamp maps to ACCESS datetime but ACCESS datetime
does not map to MySQL timestamp.
We are on ODBC 3.51.nn and MySQL 4.0.20, but we have been doing this across
several versions for 3 years.
From: Scott Hamm [mailto:linuxgold@stripped]
Sent: Friday, March 04, 2005 9:08 AM
Subject: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');
How do I create a table using:
date_format('2004-10-03 15:06:14','%m/%d/%y %T');
That way I can import Access Data?
Power to people, Linux is here.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1