MySQL Forums
Forum List  »  MySQL for Excel

escaping special characters in Mysql for excel
Posted by: Ludwig Brincat
Date: April 24, 2014 01:38PM

Hi I am using mysql for excel to insert & edit data in a mysql table but I got a problem where the user enters some reserved characters in the excel table.

I know it is possible to escape these characters when writing mysql query s manually but how can I escape characters like ";'." in excel to be able to upload to db using mysql for excel?

below is the error I am receiving

MySQL Error 1064:
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 'z application ' IS NULL AND `features` IS NULL) OR `features`='### 7" (18 cm) TF' at line 1


Options: ReplyQuote

Written By
escaping special characters in Mysql for excel
April 24, 2014 01:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.