Specifying Field Data Type LOAD DATA - MYSQL
I want to specify Field data type in following data load statement for MySQL

Use db;
LOAD DATA LOCAL INFILE 'C:/test.csv'INTO TABLE db.table1 FIELDS TERMINATED BY ','LINES TERMINATED BY '\n';

Following data sample is imported /loaded into MySQL  
Id,Name,Grade,Assignment 1
30062000,"Black",3.000000000,3.000000000
and 
when the record set is exported back data type changes
30062000,"""Black""",3,3

How can I specify the Data type during Import of sample data in the above LOAD DATA LOCAL INFILE statement

Thanks a lot
Specifying Field Data Type LOAD DATA - MYSQL
===

I want to specify Field data type in following data load statement for MySQL

Use db;
LOAD DATA LOCAL INFILE 'C:/test.csv'INTO TABLE db.table1 FIELDS TERMINATED BY ','LINES TERMINATED BY '\n';

Following data sample is imported /loaded into MySQL  
Id,Name,Grade,Assignment 1
30062000,"Black",3.000000000,3.000000000
and 
when the record set is exported back data type changes
30062000,"""Black""",3,3

How can I specify the Data type during Import of sample data in the above LOAD DATA LOCAL INFILE statement

Thanks a lot