1

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 .

Improve this question
2
  • can't reproduce, insert is fine for me... Commented Nov 8, 2016 at 10:19
  • is there any solution to this Commented Nov 8, 2016 at 10:28
Related questions
0
Problem inserting XML parsed data in MySQL tabel
0
Inserting data from xml file into mysql database
0
Error with Mysql Syntax in Python Script when Inserting into Database
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.