Posted by on Wednesday, September 1, 2010,
In :
Web
If you have a text file and if you want to Insert data to your Database Table, You can do it with these instructions and screen shots.
1. You should run some sql queries to do it on your server In my case : server (local) is ==> localhost my table is ==> ipbank and my text file is ==> ipdata.txt
2. Goto your MYSQL command prompt, I am using phpMyAdmin
3. Then Insert the queries like this LOAD DATA LOCAL INFILE '/opt/lampp/htdocs/site/ipdata.txt' INTO TABLE ipbank FIELD... Continue reading ...