[David L Morris]

Hello Cal, I am operating on Win98, localhost, with SQLyog 3.52 and here is the table definition:-

DDL Information For – aimdb.mtv030105spots

---

Table CreateTable

---

mtv030105spots CREATE TABLE `mtv030105spots` ( `AdInstanceID` bigint(20) default NULL, `AdvertisementID` int(10) default NULL, `KeyNumber` char(15) default NULL, `StationID` int(10) default NULL, `SpotDateTime` datetime default NULL, `Duration` char(3) default NULL, `BreakNumber` char(3) default NULL, `AdsInBreak` char(2) default NULL, `PositionInBreak` char(2) default NULL, `PromoBefore` char(1) default NULL, `PromoAfter` char(1) default NULL, `TypeOfAd` char(1) default NULL, `CommentCode` char(2) default NULL, `ProgramID` int(10) default NULL, `MarketInd` char(1) default NULL, UNIQUE KEY `AdInstanceID` (`AdInstanceID`), KEY `KeyNumber` (`KeyNumber`), KEY `AdvertisementID` (`AdvertisementID`) ) TYPE=MyISAM

[David L Morris]

The MySQL version is 4.0.13 and I am runing on Win98

Regards

David

[David L Morris]

Here is the history. The MySql is, I believe Version 4.0 – I only downloaded it a couple of weeks ago.

[17:14:38][ 61 ms] show fields from `aimdb`.`mtv20030105spots`

[17:14:39][ 3 ms] show keys from `aimdb`.`mtv20030105spots`

[17:14:39][ 2 ms] show create table `aimdb`.`mtv20030105spots`

[17:14:47][ 3 ms] use `aimdb`

[17:14:47][ 4 ms] show fields from `aimdb`.`mtv20030105spots`

[17:14:47][ 9 ms] show table status from `aimdb` like 'mtv20030105spots'

[17:14:54][ 4 ms] show keys from `aimdb`.`mtv20030105spots`

[17:14:54][1122 ms] create table `aimdb`.`mtv20030105spots_copy` ( primary key ( AdInstanceID ) ,FULLTEXT KEY `KeyNumber` ( `KeyNumber` ), FULLTEXT KEY `AdvertisementID` ( `AdvertisementID` ) )type=MyISAM select `AdInstanceID`, `AdvertisementID`, `KeyNumber`, `StationID`, `SpotDateTime`, `Duration`, `BreakNumber`, `AdsInBreak`, `PositionInBreak`, `PromoBefore`, `PromoAfter`, `TypeOfAd`, `CommentCode`, `ProgramID`, `MarketInd` from `aimdb`.`mtv20030105spots` where 1 = 0

[17:14:59][ 2 ms] use `aimdb`

I still get the error and hope this gives you a clue.

David

[David L Morris]

Thanks for the offer Ritesh, however, after scanning the MySQL Manual in the nine pages covering LOAD DATA INFILE Syntax, I changed my LINES TERMINATED BY 'n' to 'rn', set the fileds enclosed by ” Optionally and the imports of all my csv files worked perfectly.

I have about 28 days to go on my trial, but I think you can count on a sale.

Regards

David

[David L Morris]

Sorry Shadow, I tried your suggestion, but when I select:-

Fields OPTIONALLY enclosed by: “

I import one record which still has quotes. Here is the display after the import and F5:-

3006 “Boots Healthcare Australia P/L” 3007,”Advanced H

Using XTREE to display the csv file in Hex, I can see the EOL is the normal hex 0D0A

I have over 70K records to import from a larger CSV and I would dearly like to get the import to work

as the speed of import is great. I have attached a similar CSV file if it would help.

[Author]

Posts