Getting syntax error while inserting string of XML data in column of data type LongText

Asked Nov 08 '16 at 10:13

Active Nov 08 '16 at 10:15

Viewed 135 times

I am using the My SQL Server 5.0 and My SQL Query Browser 1.1

     INSERT INTO `service_settings` (`service_id`,`settings`) VALUES
 (17,'<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\r\n<SecurityDataRepository>\r\n <SecurityPriceSheet>        \r\n        <first50Pages>1</first50Pages>\r\n      <additionalPages>0.5</additionalPages>\r\n      <staasLitePrice>500</staasLitePrice>\r\n        <serviceUnitPrice>600</serviceUnitPrice>\r\n        <toolUnitPrice>1200</toolUnitPrice>\r\n </SecurityPriceSheet>\r\n</SecurityDataRepository>');

I am getting a syntax error( Error No. 1064) while inserting the String in column of datatype LONGTEXT I have gone through previous threads like this but it did not work for me .