I'm trying to export grid rows to a file as SQL inserts, and run the inserts in an identical table in another database. The problem is that one of the fields in the exported rows contains a "'" (single quote) as part of a valid street address.
HeidiSQL exports the rows as SQL inserts without failure, but when running the SQL inserts against the other DB, I get a syntax error because of the unescaped single quote. See image below for my settings.
Is there a way to get around this in today's HeidiSQL? Is it possible to take into account characters that need to be escaped when exporting grid rows to SQL inserts? (I guess this will also affect the other SQL command exports)
Thank you in advance!