.net

<connectionStrings> <add name="con" connectionString="Data Source=SERVER NAME;Initial Catalog=datamining;Persist Security Info=True;User ID=sa;Password=root"/> </connectionStrings> <appSettings> <add key="connection".

Import CSV File into MYSQL Query Browser : Simple Query:  LOAD DATA LOCAL INFILE 'E:/123.csv' INTO TABLE documentupload FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; After that i used “select * from test_table”. The data are disp.

t.