This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
The following SQL does not display properly though it is legitimate SQL INSERT INTO USER_SETTING (USER_ID, SETTINGS) SELECT ID,"{\"nutrientOrdering\":[{\"text_id\":\"201\", \"order\":1, \"group\":1}]" FROM USER WHERE NAME="GUEST";
Not is not valid SQL - it is "MySQL-SQL". Standard SQL quotes the quoting sign by repeating it. So this is an example with correct SQL (from "Corrected INSERT" onwards): -- Prepare example create table USER (ID integer primary key auto_increment, name varchar(255)); create table USER_SETTING(USER_ID integer, SETTINGS TEXT); insert into USER VALUES (1, 'GUEST'); -- Corrected INSERT INSERT INTO USER_SETTING (USER_ID, SETTINGS) SELECT ID,"{""nutrientOrdering"":[{""text_id"":""201"", ""order"":1, ""group"":1}]" FROM USER WHERE NAME="GUEST";