LOAD DATA LOCAL INFILE into Mysql table

[rajesh_rk]

hi ,

iam using this code ,to load my csv file in to mysql table using PHPmyAdmin...

LOAD DATA LOCAL INFILE 'C:/Program Files/EasyPHP1-8/www/ tools/xball_6066f.csv' INTO TABLE
temp_2g FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES
TERMINATED B

by using this query my file is loaded ,

but when i import values from my csv file, , but iam getting NULL values,

can anybody help me out on this, more over my CSV file is not null,

regards
rajesh

[sneakyimp]

your post is not entirely clear. the SQL you posted is only partially complete. are all values null? does each record have some null values?

you should keep in mind that your database table must match your data or you have to tell the LOAD DATA command which data fields it is importing from the CSV file. also, if your CSV data is the wrong kind of information for your database, you will get empty values . For instance, if you tried to put 'foobar' in a data field that was of type INT or DEC.