SQL Server to Mysql migration (using Mysql Workbench). How to add data with manually escaped apostrophe during steps in Workbench wizard?
<p>I know how to escape apostrophe. The question is different. How to add data with manually escaped apostrophe during steps in Workbench wizard? </p>

<p>I have the same question as in
<a href="https://stackoverflow.com/questions/34232203/sql-server-to-mysql-migration-using-mysql-workbench-data-transfer-error">SQL Server to Mysql migration (using Mysql Workbench) data transfer error</a></p>

<p>How can I manually add escape to apostrophe (') and then run the last step in workbench wizard for DATA MIGRATION?  </p>

<p>My error is different: 
Statement execution failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right 
syntax to use near 's Homestead','Regina Murphy','Sales Representative','707 Oxford Rd.','Ann Arbor'' at line 1:</p>

<pre><code>INSERT INTO `Northwind`.`Suppliers` (`SupplierID`, `CompanyName`, `ContactName`, `ContactTitle`, `Address`, `City`, `Region`, `PostalCode`, `Country`, `Phone`, `Fax`, `HomePage`)

VALUES

(3,'Grandma Kelly's Homestead','Regina Murphy','Sales Representative','707 Oxford Rd.','Ann Arbor','MI','48104','USA','(313) 555-5735','(313) 555-3349',NULL),
</code></pre>

<p>It looks like apostrophe in word  "Kelly's" produce the problem.</p>