demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / x$statements_with_errors_or_warnings

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, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - ...

(Query took 0.0050 seconds.)

SELECT * FROM `x$statements_with_errors_or_warnings`

Filter rows:

Partial texts

Full texts

Show binary contents

Show BLOB contents

Hide browser transformation

Well Known Text

Well Known Binary

query	db	exec_count	errors	error_pct	warnings	warning_pct	first_seen	last_seen	digest
SHOW TABLES FROM `phpmyadmin`	NULL	5818	5818	100.0000	0	0.0000	2024-06-30 13:31:00.864555	2024-06-30 13:43:01.775205	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `Nadia_20` WHERE `Name` LIK...	NULL	68	68	100.0000	0	0.0000	2024-06-30 13:37:10.947718	2024-06-30 13:39:53.693978	ba2625e620ba7592d0de3fac4e926fa116d12647e97f88ecc2...
SELECT ? FROM `Nadia_20` . `products` LIMIT ?	NULL	45	45	100.0000	0	0.0000	2024-06-30 13:37:10.971723	2024-06-30 13:39:53.719361	99beb81d7d47f77a43630b2768a6d6fd9b0ab7526cb85018e7...
SHOW TABLE STATUS FROM `325` WHERE `Name` LIKE ?	NULL	24	24	100.0000	0	0.0000	2024-06-30 13:31:00.899975	2024-06-30 13:41:20.768643	861b37db73d502574b2bca0eec003ca58a76b4d88538c328bc...
SELECT ? FROM `325` . `sid` LIMIT ?	NULL	23	23	100.0000	0	0.0000	2024-06-30 13:31:00.979918	2024-06-30 13:41:20.797566	b56b1bb8bb6d545152da4f34285a553294f1d370dd7b8105c1...
SHOW TABLES FROM `325`	NULL	17	17	100.0000	0	0.0000	2024-06-30 13:31:01.031976	2024-06-30 13:40:32.982679	ed546f7e44cc9770950cdba4cb40090565194fe9395ed8a67a...
SHOW TABLE STATUS FROM `point` WHERE `Name` LIKE ?	NULL	17	17	100.0000	0	0.0000	2024-06-30 13:38:57.747009	2024-06-30 13:39:41.693143	1a1da7a75b556991cb8fb145d65b26f2101184a78dde1bec3e...
SHOW TABLES FROM `shree handlooms.in`	NULL	16	16	100.0000	0	0.0000	2024-06-30 13:38:23.899660	2024-06-30 13:39:43.979830	f2fb5dc22f778a1c95d0911ed9d3777366777f749590e602c0...
SELECT ? FROM `Nadia_20` . `categories` LIMIT ?	NULL	15	15	100.0000	0	0.0000	2024-06-30 13:37:42.831085	2024-06-30 13:39:51.872590	349e108892eef39a6d2fc0e759f86a4bde12d20666196774dc...
SELECT ? FROM `point` . `uploads` LIMIT ?	NULL	15	15	100.0000	0	0.0000	2024-06-30 13:38:57.767067	2024-06-30 13:39:41.711523	cd980d73e9b4067c63e7d793962be05777694fbb0f2de59d32...
SHOW TABLES FROM `multiuser_Theophan`	NULL	14	14	100.0000	0	0.0000	2024-06-30 13:34:10.307567	2024-06-30 13:39:54.805127	9e9b7a2761c1c12c5a429533783b201204572d73a9d4b05515...
SHOW TABLES FROM `chirag sharma21`	NULL	10	10	100.0000	0	0.0000	2024-06-30 13:31:04.783849	2024-06-30 13:38:26.965961	71e805c3f0d36c13298b39696fdbb8582ed05217852d22a400...
SHOW TABLES FROM `GOLIS`	NULL	9	9	100.0000	0	0.0000	2024-06-30 13:39:39.483013	2024-06-30 13:41:50.024977	53e2135ba0be6b32dd41448ca982bca7d037bbde36a736ad50...
SHOW FULL FIELDS FROM `325` . `sid`	NULL	8	8	100.0000	0	0.0000	2024-06-30 13:41:15.859424	2024-06-30 13:41:18.843329	1ecf8f4e269babbd9bef484523849c8d6f98c5ad50766e2d3b...
SHOW TABLES FROM `sql`	NULL	7	7	100.0000	0	0.0000	2024-06-30 13:40:41.535425	2024-06-30 13:41:24.289555	9ff4df5331ad042a693ec62f53596311f4112d6266bbf14f1c...
SHOW TABLES FROM `Nadia_20`	NULL	6	6	100.0000	0	0.0000	2024-06-30 13:37:16.875946	2024-06-30 13:37:48.432566	3b854fc936a1d5c1176359a939371845dba74a6ef917ef0090...
SHOW TABLES FROM `sxfs`	NULL	5	5	100.0000	0	0.0000	2024-06-30 13:31:04.465719	2024-06-30 13:34:05.766001	a431214712f19e9710ce0607d2f75320d7a62b53d86ee0b37d...
SHOW TABLES FROM `data`	NULL	4	4	100.0000	0	0.0000	2024-06-30 13:40:37.726233	2024-06-30 13:40:40.579141	262e8250178bbe3048da6129391f059769a567cf82b521ff7a...
SELECT * FROM `325` . `sid` LIMIT ?	NULL	4	4	100.0000	0	0.0000	2024-06-30 13:41:15.860586	2024-06-30 13:41:18.843575	7577c086587f13096bb100e91a9e9841e0b249b359c5251a71...
SHOW CREATE TABLE `325` . `sid`	NULL	4	4	100.0000	0	0.0000	2024-06-30 13:41:15.861058	2024-06-30 13:41:18.843763	2aed20f0b6c439930d30108d7cdf9c510b72e16889b4b8e26e...
SELECT COUNT ( * ) FROM `Nadia_20` . `products`	NULL	3	3	100.0000	0	0.0000	2024-06-30 13:37:35.160024	2024-06-30 13:39:53.645671	ddb3207758d93d72854404e127ef13f1183d85336e45321118...
SHOW TABLE STATUS FROM `sql` WHERE `Name` LIKE ?	NULL	3	3	100.0000	0	0.0000	2024-06-30 13:40:44.704422	2024-06-30 13:40:44.754467	8d217c5c7f9783b6e172639b955ca2d77cb74776f2a8d14b53...
SHOW TABLE STATUS FROM `capstone` WHERE `Name` LIK...	NULL	3	3	100.0000	0	0.0000	2024-06-30 13:35:49.110734	2024-06-30 13:35:49.163728	784bf420fc5e71eece82c6a41b58bd9b7fa3213fb90d1e81ad...
SHOW TABLES FROM `point`	NULL	2	2	100.0000	0	0.0000	2024-06-30 13:39:00.882866	2024-06-30 13:39:02.807473	bdd82f14f2e191ba9d816a5e3b061c4e7463dc27c066af54d3...
SHOW TABLES FROM `abdo`	NULL	2	2	100.0000	0	0.0000	2024-06-30 13:31:04.286185	2024-06-30 13:31:04.386794	ee34abd3e85bf19359dd0a0674afa51f66df84607a6fe8e497...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!