Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.


kalvaro's profile image kalvaro posted 9 years ago in General Permalink
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.