phpMyAdmin setup

SQL queries

SQL queries

SQL queries settings.

Show SQL queries Defines whether SQL queries generated by phpMyAdmin should be displayed.
Confirm DROP queries Whether a warning ("Are your really sure…") should be displayed when you're about to lose data.
Query history length How many queries are kept in history.
Ignore multiple statement errors If enabled, phpMyAdmin continues computing multiple-statement queries even if one of the queries failed.
Maximum displayed SQL length Maximum number of characters used when a SQL query is displayed.
Retain query box Defines whether the query box should stay on-screen after its submission.
Enable CodeMirror Use user-friendly editor for editing SQL queries (CodeMirror) with syntax highlighting and line numbers.
Enable linter Find any errors in the query before executing it. Requires CodeMirror to be enabled.
Enable autocomplete for table and column names Autocomplete of the table and column names in the SQL queries.
Foreign key checks Default value for foreign key checks checkbox for some queries.
Permanent query history Enable if you want DB-based query history (requires phpMyAdmin configuration storage). If disabled, this utilizes JS-routines to display query history (lost by window close).