Archive for November 2012
ConnectionStrings in ASP.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" value="server=SERVER NAME;user id=sa;password=root;initial catalog=Hindustan;pooling=false"/>
</appSettings>
Import CSV File into MYSQL Query Browser
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 displayed
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 displayed
Thursday, November 1, 2012
Posted by ஆனந்த் சதாசிவம்
