Hi, i'm working on migrating csv data into MySQL using jsp.
I would like to know if the sql statement shown below can be used in jsp and where i can get examples on the codes.
String sql3 = "LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE test FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'";
Please do help. Thank u =)