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 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. 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 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. 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
Archived
This topic is now archived and is closed to further replies.