Forum Moderators: coopster

Message Too Old, No Replies

How to add these into mySQL database?

         

irock

7:42 pm on Jul 2, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



My site will be using geo-targeting pretty soon... and I was wondering if you have any ideas how to insert this huge database into 1 mySQL table.

"IPFROM","IPTO","COUNTRY_SHORT","COUNTRY_LONG"
"332132128","355993887","US","UNITED STATES"
"355993888","355993895","IT","ITALY"
"355993896","368674047","US","UNITED STATES"
"368674048","368674303","ES","SPAIN"
"368674304","386665695","US","UNITED STATES"
"386665696","386665727","GB","GREAT BRITAIN"

I believe there are four columns.

Appreciate any pointers you can give me.

ExpLarry

7:52 pm on Jul 2, 2004 (gmt 0)

10+ Year Member



"LOAD DATA INFILE" might be what you are looking for, look here for more info:
[dev.mysql.com...]