mysql - Getting syntax error while inserting string of XML data in column of data type LongText -
i using sql server 5.0 , sql query browser 1.1
insert `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 getting syntax error( error no. 1064
) while inserting string in column of datatype longtext
have gone through previous threads like this did not work me .
Comments
Post a Comment