tomasd Posted October 24, 2007 Share Posted October 24, 2007 Hi, I've got some names I need to insert to my mysql table, the strings are separated by ";" look like this; house-name, city country; house-name, city country; house-name, city country and so on... how do I import all that data to a particular row in a table? Thanks for your help! Quote Link to comment https://forums.phpfreaks.com/topic/74582-please-help-to-import-data-to-mysql/ Share on other sites More sharing options...
fenway Posted October 24, 2007 Share Posted October 24, 2007 Check out LOAD DATA INFILE in the refman -- your delimiters can be just about anything. Quote Link to comment https://forums.phpfreaks.com/topic/74582-please-help-to-import-data-to-mysql/#findComment-377025 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.