mysqldump-to-csv
mysqldump-to-csv copied to clipboard
yashsmehta
removing '
I can't figure out where this is happening, but when you remove 'werwe' the '' from a field, what is happening. We are optionally enclosed our columns with ' ' The reason is, that each export has quotes in it that are not escaped properly. thus with the escpaced values. It's leaving commas unescaped which breaks the import. Therefore in our dump we have ' and our import is optionally escaped by 'data's' Like so. If you get my drift. What is happening, is that your script is removing the ' '. Which then leaves our unescpaed commas open to break the script. The export mysqldump exported with optionally enclosed of ' data '. Which when removed breaks the sequence because it's being used to enclose the values. How can I modify the script to not remove single quots.