Re: Import Access Tables
>I am now trying to load a csv file into my MySQL table and I am getting errors and I cant figure out why…
To load data, try this query -
LOAD DATA LOCAL INFILE 'F:/TEMP/incident_case.csv' INTO TABLE coordinates_database.incident_case
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';
Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/
Subject
Views
Written By
Posted
16504
December 18, 2009 01:42PM
9843
December 18, 2009 03:58PM
6336
December 21, 2009 02:10AM
Re: Import Access Tables
4701
December 21, 2009 02:16AM
3976
December 21, 2009 08:46AM
3968
December 21, 2009 09:51AM
5034
January 04, 2010 07:56AM
3823
January 20, 2010 02:16PM
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.