HI,

When want to export table in csv and load in MySQL i m using

EXPORT TO C:\KFPSMIG\latestlivekfpsdata\livecsvkfps\KFPSCND. csv OF CSV MODIFIED BY chardel"" coldel, decpt. datesiso decplusblank MESSAGES C:\KFPSMIG\latestlivekfpsdata\livecsvkfps\KFPSCND. txt select * from KFPSCND ;

to export

and

LOAD DATA LOCAL INFILE 'KFPSCND.csv' INTO TABLE kfps.KFPSCND FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\'

to Load in MySQL

but while i am Loading in Mysql many records are skipping in MySQL whats could be the problem please help

are we allowed to see any of the rows which are failing to load
and or the column defintions
and or any error messages

have you tried loading a small amount of records using say the query browser, or some other tools such as PHPMyAdmin

Operating system is Windows XP

when i use fields terminated by '\t' all the rows insert but when not null values shown for varchar and same as for bigint

when i use fields terminated by ',' rows are skipped as (2,4,6,....)no rows for (1,3,5) dont know how

so what is different between the the odd and even numbered rows
have you allowed for null values in the db
operating system may be a problme if you are mixing your capitalisations.. XP can reject or accept different capitalisation.. *NIX boxes will always reject different CaPiTalisations

as its a CSV I'd suggest delinitiating columns with a comma unless your data stream includes commas.

ive alwasy encapsulated text columns in a character (usually)

date times often trip up imports


still it would be nice to know what data you are importing,
what the table definition is
and what the MySQL error message(s) is/are

um, WTF??? delinitiating ?????????

Picky, picky, picky...

Just because he couldn't spell delimitatatizing.

-PatP

seemed fair enough to me

delineated: represented accurately or precisely

ok it was badly spellt, but as any fule no I can't, don't, seem unable to spell check or proof read

Please tell how to load in mysql so that blank cell in csv replaces to null in table in which we are loading

without seeing your data or your table defintions its hard to say