There is a request

ALTER TABLE jos_md_catalog_model MODIFY {"label":null,"type":null,"lookup_table":"jos_md_catalog_year","lookup_nameas":null,"lookup_idas":null,"lookup_filter":null} COMMENT '';

If the connection string contains a base, then everything works fine. If not specified, the No Select Database crashes accordingly. I finalized all other queries with an indication of a specific database, using key phrases such as FROM, IN. And with this request, I did not find such an option.

  • and the table did not try to specify the database name, such as alter table db_name.table_name ... - Mike
  • starts to swear. {"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{""label"":null,""type"":null,""lookup_table"":""jos_md_catalog_year"",""lookup_nameas"":n' at line 1"} - Dmitry Gvozd
  • You have an error in the ALTER TABLE syntax after MODIFY; you can specify only one column, without braces and in the format adopted in MySQL without a colon. If you need to change several columns, you need to specify several MODIFY expressions separated by commas. It seems that after MODIFY you just have a hash that is not converted to MySQL. - cheops
  • you are mistaken, there are no errors there, the JSON text and the essence of the question are described above. - Dmitry Nail
  • Something I do not see JSON in MODIFY: dev.mysql.com/doc/refman/5.7/en/alter-table.html - Alex

0