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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.