sql_quote_show

sql_quote_show_create

User, date	Message
Written by kalvaro 2 years ago Category: General 441 posts since Thu, 29 Nov 07	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. Username: Password: Remember me

User, date

Message

Written by kalvaro
2 years ago
Category: General
441 posts since Thu, 29 Nov 07

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.