CSV into mysql?
Posted: Sat May 17, 2003 2:05 pm
Let's say i have file like this:
And i want to put it in mysql, but i can't use "load file" becaouse phpmyadmin shows me "The used command is not allowed with this MySQL version (4.0.12)"
Does anyone have a clew how to solve this?
Code: Select all
"3230826240","3230827007","US","UNITED STATES"
"3230827520","3230827775","AT","AUSTRIA"
"3230827776","3230828031","NZ","NEW ZEALAND"
"3230828032","3230828543","HU","HUNGARY"
"3230828544","3230830079","GB","UNITED KINGDOM"Does anyone have a clew how to solve this?