Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
General
Set some commonly used options.
General
Documentation Enables check for latest version on main phpMyAdmin page. Restore default value
Documentation Use natural order for sorting table and database names. Restore default value
Documentation Restore default value
Documentation Define how long (in seconds) a login cookie is valid. Restore default value
Documentation Mark used tables and make it possible to show databases with locked tables. Restore default value
Documentation Disable the table maintenance mass operations, like optimizing or repairing the selected tables of a database. Restore default value
Documentation Whether to show hint or not. Restore default value
Documentation Choose the default action when sending error reports. Restore default value
Documentation Queries are executed by pressing Enter (instead of Ctrl+Enter). New lines will be inserted with Shift+Enter. Restore default value
Documentation Disable shortcut keys Restore default value
Documentation Restore default value
Databases
Databases
Documentation You can use MySQL wildcard characters (% and _), escape them if you want to use their literal instances, i.e. use 'my\_db' and not 'my_db'. Restore default value
Documentation Hide databases matching regular expression (PCRE). Restore default value
Documentation Maximum number of databases displayed in database list. Restore default value
Documentation Maximum number of tables displayed in table list. Restore default value
Documentation Restore default value
Text fields
Customize text input fields.
Text fields
Documentation Defines which type of editing controls should be used for CHAR and VARCHAR columns; input - allows limiting of input length, textarea - allows newlines in columns. Restore default value
Documentation Defines the minimum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Defines the maximum size for input fields generated for CHAR and VARCHAR columns. Restore default value
Documentation Number of columns for CHAR/VARCHAR textareas. Restore default value
Documentation Number of rows for CHAR/VARCHAR textareas. Restore default value
Documentation Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2). Restore default value
Documentation Double size of textarea for LONGTEXT columns. Restore default value
Page titles
Specify browser's title bar text. Refer to documentation for magic strings that can be used to get special values.
Page titles
Documentation Title of browser window when nothing is selected. Restore default value
Documentation Title of browser window when a table is selected. Restore default value
Documentation Title of browser window when a database is selected. Restore default value
Documentation Title of browser window when a server is selected. Restore default value
Warnings
Disable some of the warnings shown by phpMyAdmin.
Warnings
Documentation Disable the default warning that is displayed on the database details Structure page if any of the required tables for the phpMyAdmin configuration storage could not be found. Restore default value
Documentation Disable the default warning that is displayed on the main page if Suhosin is detected. Restore default value
Documentation Disable the default warning that is displayed on the main page if the value of the PHP setting session.gc_maxlifetime is less than the value of `LoginCookieValidity`. Restore default value
Documentation Disable the default warning that is displayed on the Structure page if column names in a table are reserved MySQL words. Restore default value
Console
Console
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Restore default value