Import CVS File into MySQL database?
Friday, 24 October 2008 01:06
Kategori : MySQL | 0 | 1418 views

  I have more than 70.000 row data to execute and input to mySQL database..
hmm... Think fast.. CVS file is the solution for upload all the data to your database server.. don't think to do import SQL query... It cannot be done.. so slow.. and waste your time... maybe can be memory leak..

  I have CVS file with more than 70.000 row data, 1 row with 5 field data, with total size 3.818 KB. I should compress the CVS file into zip file to import into MySQL. Wow.... The file size now is 512 KB.. so tiny with more than 70.000 row data on that..

  How to Import CVS file into MySQL :

1. You Should Compress the cvs file.. in this case I use "WinRar" to compress this file.. then I changed the output file extension from ".rar" into ".zip"



2. Change Field Terminated By to "," and Lines to "\n". see the picture..

Done.

Hope it Works to You..
Yupi Sugianto.


Comments..

 Sponsor Link 

Add Comment

Name (required)
Mail (will not be published) (required)
Website

CAPTCHA Image
Security Code (required) Reload Image

Visitor
There were 15554 user(s) here
Your IP : 38.107.191.94
Your Browser : Unknown
Country : UNITED STATES
~~~~~~~~
Latest Visitor
10thSep10 02:17| UNITED STATES
10thSep10 02:10| UNITED STATES
10thSep10 02:09| UNITED STATES
10thSep10 02:09| UNITED STATES
10thSep10 02:09| UNITED STATES
10thSep10 01:51| UNITED STATES
10thSep10 01:49| INDONESIA
10thSep10 01:48| UNITED STATES
10thSep10 01:47| UNITED STATES
Search Subject |Auto Complete

Links