Insert Or Update Text-field With Raw Value "find_in_set(…)"

[Meinolf]

I save sql-commands manually in a column. Normally it works fine and the whole command will be inserted properly (automatically masked at insert or update).

 

A value like ” find_in_set(…) ” will not be inserted properly, the program tries to interpret it! The quotation marks are not present.

 

The created sql is wrong: insert into tablename (columns-names) values (…, FIND_IN_SET(..,..), … );

 

It should be something like this: insert into tablename (columns-names) values (…, “FIND_IN_SET(..,..)”, … );

 

I know it is a rarely used value…

 

With best regards,

Swen

 

OS: you are doing great work!

 

[sathish]

Hello,

 

Please refer this FAQ: http://faq.webyog.com/content/8/116/en/can-i-use-functions-with-sqlyog-data-and-result-panes.html Which describes how to handle FUNCTIONS in table data or result pane. 

 

Regards,

Sathish

[Author]

Posts