ldoozer Posted November 7, 2007 Share Posted November 7, 2007 Hi all, I have a db table of banned words that is used to flag up forum posts with banned words in. the fields are- id and word. I have been given a csv list of all the words needed to be imported but do not know the best/most efficent way of importing them in to the table. I have phpmyadmin installed on the server if that helps? Any help would be appreciated. Thanks Ldoozer Link to comment https://forums.phpfreaks.com/topic/76418-insertingimporting-csv/ Share on other sites More sharing options...
fenway Posted November 7, 2007 Share Posted November 7, 2007 First, there's a CSV table table! Second, look at the LOAD DATA INFILE syntax -- you can load any delimited file. Link to comment https://forums.phpfreaks.com/topic/76418-insertingimporting-csv/#findComment-387058 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.