mikebyrne Posted April 6, 2009 Share Posted April 6, 2009 Im trying to insert a csv file into my database but im getting the error "Invalid parameter for CSV import: Fields escaped by" A line on my file looks like this: ,6778,Bxxxn,Anxxe,,76 Whxxxxecxxastle Lawn,Axxxy,Co.Kxxxare, What should I place in the following?? Fields terminated by Fields enclosed by Fields escaped by Lines terminated by Quote Link to comment https://forums.phpfreaks.com/topic/152861-inserting-csv-file-in-phpmyadmin/ Share on other sites More sharing options...
gizmola Posted April 6, 2009 Share Posted April 6, 2009 Your Fields are terminated by a ',' . Hopefully there are no embedded commas in the addresses anywhere as that will completely screw up your import. Quote Link to comment https://forums.phpfreaks.com/topic/152861-inserting-csv-file-in-phpmyadmin/#findComment-802756 Share on other sites More sharing options...
mikebyrne Posted April 6, 2009 Author Share Posted April 6, 2009 I leave the rest blank but still get the "Fields escaped by" error Quote Link to comment https://forums.phpfreaks.com/topic/152861-inserting-csv-file-in-phpmyadmin/#findComment-802836 Share on other sites More sharing options...
gizmola Posted April 8, 2009 Share Posted April 8, 2009 The default would be a \ character. If there's no reason not to use that, then go with it. Quote Link to comment https://forums.phpfreaks.com/topic/152861-inserting-csv-file-in-phpmyadmin/#findComment-804214 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.