Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: mysql
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
columns_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_bin 9 KiB -
column_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
db   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 MyISAM utf8_bin 11.5 KiB -
event   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 2 KiB -
func   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 1 KiB -
general_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 CSV utf8_general_ci unknown -
gtid_slave_pos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 16 KiB -
help_category   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 39 MyISAM utf8_general_ci 4.1 KiB -
help_keyword   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 464 MyISAM utf8_general_ci 105.3 KiB -
help_relation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,028 MyISAM utf8_general_ci 28 KiB -
help_topic   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 508 MyISAM utf8_general_ci 416 KiB -
host   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 2 KiB -
index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
innodb_index_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,065 InnoDB utf8_bin 1.5 MiB -
innodb_table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,333 InnoDB utf8_bin 144 KiB -
plugin   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
proc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 MyISAM utf8_general_ci 5.1 KiB -
procs_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_bin 11.2 KiB -
proxies_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_bin 12.5 KiB 1,269 B
roles_mapping   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 4 KiB -
servers   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
slow_log   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 CSV utf8_general_ci unknown -
tables_priv   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_bin 11.2 KiB -
table_stats   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_bin 2 KiB -
time_zone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_leap_second   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_name   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1 KiB -
user   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 MyISAM utf8_bin 4.6 KiB -
30 tables Sum 9,460 InnoDB latin1_swedish_ci 2.3 MiB 1.2 KiB
/ Check tables having overhead

Print view Print view Data dictionary Data dictionary

  Create table
Name:
Number of columns:
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
object,
integer 1,
)
./libraries/DatabaseInterface.class.php#1946: PMA_DatabaseInterface->tryQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
NULL,
integer 1,
boolean false,
)
./libraries/navigation/NavigationTree.class.php#189: PMA_DatabaseInterface->fetchValue(string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ')
./libraries/navigation/NavigationTree.class.php#100: PMA_NavigationTree->_getNavigationDbPos()
./libraries/navigation/Navigation.class.php#37: PMA_NavigationTree->__construct()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
object,
integer 1,
)
./libraries/DatabaseInterface.class.php#1946: PMA_DatabaseInterface->tryQuery(
string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ',
NULL,
integer 1,
boolean false,
)
./libraries/navigation/NavigationTree.class.php#189: PMA_DatabaseInterface->fetchValue(string 'SELECT (COUNT(DB_first_level) DIV 100) * 100 from ( SELECT distinct SUBSTRING_INDEX(SCHEMA_NAME, \'_\', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE `SCHEMA_NAME` < \'test\' ) t ')
./libraries/navigation/NavigationTree.class.php#100: PMA_NavigationTree->_getNavigationDbPos()
./libraries/navigation/Navigation.class.php#37: PMA_NavigationTree->__construct()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()