Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

Always expand query messages

Show query history at start

Show current browsing query

Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.

Switch to dark theme

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

sakila

actor

Column	Type	Null	Default
actor_id (Primary)	smallint(5)	No
first_name	varchar(45)	No
last_name	varchar(45)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	actor_id	200	A	No
idx_actor_last_name	BTREE	No	No	last_name	121	A	No

actor_info

Table comments: VIEW

Column	Type	Null	Default
actor_id	smallint(5)	No	0
first_name	varchar(45)	No
last_name	varchar(45)	No
film_info	text	Yes	NULL

No index defined!

address

Column	Type	Null	Default
address_id (Primary)	smallint(5)	No
address	varchar(50)	No
address2	varchar(50)	Yes	NULL
district	varchar(20)	No
city_id	smallint(5)	No
postal_code	varchar(10)	Yes	NULL
phone	varchar(20)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	address_id	603	A	No
idx_fk_city_id	BTREE	No	No	city_id	599	A	No

Column	Type	Null	Default
category_id (Primary)	tinyint(3)	No
name	varchar(25)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	category_id	16	A	No

city

Column	Type	Null	Default
city_id (Primary)	smallint(5)	No
city	varchar(50)	No
country_id	smallint(5)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	city_id	600	A	No
idx_fk_country_id	BTREE	No	No	country_id	109	A	No

country

Column	Type	Null	Default
country_id (Primary)	smallint(5)	No
country	varchar(50)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	country_id	109	A	No

customer

Column	Type	Null	Default
customer_id (Primary)	smallint(5)	No
store_id	tinyint(3)	No
first_name	varchar(45)	No
last_name	varchar(45)	No
email	varchar(50)	Yes	NULL
address_id	smallint(5)	No
active	tinyint(1)	No	1
create_date	datetime	No
last_update	timestamp	Yes	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	customer_id	599	A	No
idx_fk_store_id	BTREE	No	No	store_id	2	A	No
idx_fk_address_id	BTREE	No	No	address_id	599	A	No
idx_last_name	BTREE	No	No	last_name	599	A	No

customer_list

Table comments: VIEW

Column	Type	Null	Default
ID	smallint(5)	No	0
name	varchar(91)	Yes	NULL
address	varchar(50)	No
zip code	varchar(10)	Yes	NULL
phone	varchar(20)	No
city	varchar(50)	No
country	varchar(50)	No
notes	varchar(6)	No
SID	tinyint(3)	No

No index defined!

film

Column	Type	Null	Default
film_id (Primary)	smallint(5)	No
title	varchar(255)	No
description	text	Yes	NULL
release_year	year(4)	Yes	NULL
language_id	tinyint(3)	No
original_language_id	tinyint(3)	Yes	NULL
rental_duration	tinyint(3)	No	3
rental_rate	decimal(4,2)	No	4.99
length	smallint(5)	Yes	NULL
replacement_cost	decimal(5,2)	No	19.99
rating	enum('G', 'PG', 'PG-13', 'R', 'NC-17')	Yes	G
special_features	set('Trailers', 'Commentaries', 'Deleted Scenes', 'Behind the Scenes')	Yes	NULL
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	film_id	1000	A	No
idx_title	BTREE	No	No	title	1000	A	No
idx_fk_language_id	BTREE	No	No	language_id	1	A	No
idx_fk_original_language_id	BTREE	No	No	original_language_id	1	A	Yes

film_actor

Column	Type	Null	Default
actor_id (Primary)	smallint(5)	No
film_id (Primary)	smallint(5)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	actor_id	200	A	No
PRIMARY	BTREE	Yes	No	film_id	5462	A	No
idx_fk_film_id	BTREE	No	No	film_id	997	A	No

film_category

Column	Type	Null	Default
film_id (Primary)	smallint(5)	No
category_id (Primary)	tinyint(3)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	film_id	1000	A	No
PRIMARY	BTREE	Yes	No	category_id	1000	A	No
fk_film_category_category	BTREE	No	No	category_id	16	A	No

film_list

Table comments: VIEW

Column	Type	Null	Default
FID	smallint(5)	Yes	0
title	varchar(255)	Yes	NULL
description	text	Yes	NULL
category	varchar(25)	No
price	decimal(4,2)	Yes	4.99
length	smallint(5)	Yes	NULL
rating	enum('G', 'PG', 'PG-13', 'R', 'NC-17')	Yes	G
actors	text	Yes	NULL

No index defined!

film_text

Column	Type	Null	Default
film_id (Primary)	smallint(6)	No
title	varchar(255)	No
description	text	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	film_id	1000	A	No
idx_title_description	FULLTEXT	No	No	title			No
idx_title_description	FULLTEXT	No	No	description			Yes

inventory

Column	Type	Null	Default
inventory_id (Primary)	mediumint(8)	No
film_id	smallint(5)	No
store_id	tinyint(3)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	inventory_id	4581	A	No
idx_fk_film_id	BTREE	No	No	film_id	958	A	No
idx_store_id_film_id	BTREE	No	No	store_id	2	A	No
idx_store_id_film_id	BTREE	No	No	film_id	1521	A	No

language

Column	Type	Null	Default
language_id (Primary)	tinyint(3)	No
name	char(20)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	language_id	6	A	No

nicer_but_slower_film_list

Table comments: VIEW

Column	Type	Null	Default
FID	smallint(5)	Yes	0
title	varchar(255)	Yes	NULL
description	text	Yes	NULL
category	varchar(25)	No
price	decimal(4,2)	Yes	4.99
length	smallint(5)	Yes	NULL
rating	enum('G', 'PG', 'PG-13', 'R', 'NC-17')	Yes	G
actors	text	Yes	NULL

No index defined!

payment

Column	Type	Null	Default
payment_id (Primary)	smallint(5)	No
customer_id	smallint(5)	No
staff_id	tinyint(3)	No
rental_id	int(11)	Yes	NULL
amount	decimal(5,2)	No
payment_date	datetime	No
last_update	timestamp	Yes	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	payment_id	16086	A	No
idx_fk_staff_id	BTREE	No	No	staff_id	2	A	No
idx_fk_customer_id	BTREE	No	No	customer_id	599	A	No
fk_payment_rental	BTREE	No	No	rental_id	16045	A	Yes

rental

Column	Type	Null	Default
rental_id (Primary)	int(11)	No
rental_date	datetime	No
inventory_id	mediumint(8)	No
customer_id	smallint(5)	No
return_date	datetime	Yes	NULL
staff_id	tinyint(3)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	rental_id	16005	A	No
rental_date	BTREE	Yes	No	rental_date	15815	A	No
				inventory_id	16005	A	No
				customer_id	16005	A	No
idx_fk_inventory_id	BTREE	No	No	inventory_id	4580	A	No
idx_fk_customer_id	BTREE	No	No	customer_id	599	A	No
idx_fk_staff_id	BTREE	No	No	staff_id	2	A	No

sales_by_film_category

Table comments: VIEW

Column	Type	Null	Default	Comments
category	varchar(25)	No
total_sales	decimal(27,2)	Yes	NULL

No index defined!

sales_by_store

Table comments: VIEW

Column	Type	Null	Default
store	varchar(101)	Yes	NULL
manager	varchar(91)	Yes	NULL
total_sales	decimal(27,2)	Yes	NULL

No index defined!

staff

Column	Type	Null	Default
staff_id (Primary)	tinyint(3)	No
first_name	varchar(45)	No
last_name	varchar(45)	No
address_id	smallint(5)	No
picture	blob	Yes	NULL
email	varchar(50)	Yes	NULL
store_id	tinyint(3)	No
active	tinyint(1)	No	1
username	varchar(16)	No
password	varchar(40)	Yes	NULL
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	staff_id	2	A	No
idx_fk_store_id	BTREE	No	No	store_id	2	A	No
idx_fk_address_id	BTREE	No	No	address_id	2	A	No

staff_list

Table comments: VIEW

Column	Type	Null	Default
ID	tinyint(3)	No	0
name	varchar(91)	Yes	NULL
address	varchar(50)	No
zip code	varchar(10)	Yes	NULL
phone	varchar(20)	No
city	varchar(50)	No
country	varchar(50)	No
SID	tinyint(3)	No

No index defined!

store

Column	Type	Null	Default
store_id (Primary)	tinyint(3)	No
manager_staff_id	tinyint(3)	No
address_id	smallint(5)	No
last_update	timestamp	No	CURRENT_TIMESTAMP

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null
PRIMARY	BTREE	Yes	No	store_id	2	A	No
idx_unique_manager	BTREE	Yes	No	manager_staff_id	2	A	No
idx_fk_address_id	BTREE	No	No	address_id	2	A	No

phpMyAdmin Demo Server: Git information missing!