distal-attribute
distal-attribute
distal-attribute
distal-attribute

sql_quote_show_create

kalvaro posted 4 years ago in General
I've been disabling the sql_quote_show_create session variable while testing stuff for a PHP script that makes use of SHOW CREATE TABLE.

I've discovered that setting it to OFF breaks a great deal of HeidiSQL's features: table editor, data tab... I'd say that the column parser does not recognise unquoted identifiers. I'm not sure if it's a known issue (a ticket search for "sql_quote_show_create" doesn't return results).

It can be disabled from the "Host/Variables" tab or by running:

SET @@session.sql_quote_show_create = 'OFF';

Please login to leave a reply, or register at first.