demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sakila / customer_list

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:

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Current selection does not contain a unique column. Grid edit, Edit, Copy and Delete features may result in undesired behavior.

Showing rows 0 - ...

(Query took 0.0092 seconds.)

SELECT * FROM `customer_list`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Geometry

Well Known Text

Well Known Binary

			ID	name	address	zip code	phone	city	country	notes	SID
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 52	52	JULIE SANCHEZ	939 Probolinggo Loop	4166	680428310138	A Corua (La Corua)	Spain	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 101	101	PEGGY MYERS	733 Mandaluyong Place	77459	196568435814	Abha	Saudi Arabia	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 452	452	TOM MILNER	535 Ahmadnagar Manor	41136	985109775584	Abu Dhabi	United Arab Emirates	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 486	486	GLEN TALBERT	1789 Saint-Denis Parkway	8268	936806643983	Acua	Mexico	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 327	327	LARRY THRASHER	663 Baha Blanca Parkway	33463	834418779292	Adana	Turkey	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 392	392	SEAN DOUGLASS	614 Pak Kret Street	27796	47808359842	Addis Abeba	Ethiopia	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 210	210	ELLA OLIVER	751 Lima Loop	99405	756460337785	Aden	Yemen	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 367	367	ADAM GOOCH	230 Urawa Drive	2738	166898395731	Adoni	India	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 297	297	SHERRI RHODES	922 Vila Velha Loop	4085	510737228015	Ahmadnagar	India	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 574	574	JULIAN VEST	923 Tangail Boulevard	33384	315528269898	Akishima	Japan	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 479	479	ZACHARY HITE	98 Pyongyang Boulevard	88749	191958435142	Akron	United States	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 98	98	LILLIAN GRIFFIN	669 Firozabad Loop	92265	412903167998	al-Ayn	United Arab Emirates	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 70	70	CHRISTINA RAMIREZ	1124 Buenaventura Drive	6856	407733804223	al-Hawiya	Saudi Arabia	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 590	590	SETH HANNON	1759 Niznekamsk Avenue	39414	864392582257	al-Manama	Bahrain	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 395	395	JOHNNY TURPIN	1152 Citrus Heights Manor	5239	765957414528	al-Qadarif	Sudan	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 417	417	TRAVIS ESTEP	289 Santo Andr Manor	72410	214976066017	al-Qatif	Saudi Arabia	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 33	33	ANNA HILL	127 Purnea (Purnia) Manor	79388	911872220378	Alessandria	Italy	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 175	175	ANNETTE OLSON	431 Xiangtan Avenue	4854	230250973122	Allappuzha (Alleppey)	India	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 414	414	VINCENT RALSTON	397 Sunnyvale Avenue	55566	680851640676	Allende	Mexico	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 359	359	WILLIE MARKHAM	1623 Kingstown Drive	91299	296394569728	Almirante Brown	Argentina	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 551	551	CLAYTON BARBEE	1407 Pachuca de Soto Place	26284	380077794770	Alvorada	Brazil	active	2
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 225	225	ARLENE HARVEY	1014 Loja Manor	66851	460795526514	Ambattur	India	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 415	415	GLENN PULLEN	992 Klerksdorp Loop	33711	855290087237	Amersfoort	Netherlands	active	1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 534	534	CHRISTIAN JUNG	949 Allende Lane	67521	122981120653	Amroha	India		1
Edit	Copy	Delete DELETE FROM customer_list WHERE `customer_list`.`ID` = 307	307	JOSEPH JOY	1354 Siegen Street	80184	573441801529	Angra dos Reis	Brazil	active	2

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!