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.0055 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	1149	1149	100.0000	0	0.0000	2024-06-16 10:01:02.472579	2024-06-16 10:09:19.842895	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SELECT `sakila` . `film` . `film_id` AS `FID` , `s...	sakila	18	17	94.4444	1	5.5556	2024-06-16 10:03:41.626669	2024-06-16 10:03:54.590883	b6732f8a2af10551fb443fd31239c4a58d09f97634ca7ec0b6...
SELECT `sakila` . `film` . `film_id` AS `FID` , `s...	sakila	6	6	100.0000	0	0.0000	2024-06-16 10:01:02.767265	2024-06-16 10:01:04.817147	cba681bde5c6705f7ab9727fce54429aa4ae716b050716fe24...
SELECT ? FROM `hi-db-demo` . `users` LIMIT ?	NULL	3	3	100.0000	0	0.0000	2024-06-16 10:01:45.472748	2024-06-16 10:02:46.448136	08df2e3244691feb3b1133ddecfd451219756e271a61ac5535...
SHOW TABLES FROM `acme`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:06:44.126700	2024-06-16 10:06:44.161361	fd802ae4a4f74d373a0ade12c9bebd4a8b523cf2f9508142b3...
SHOW TABLES FROM `dbms_kampus`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:06:44.809905	2024-06-16 10:06:44.843527	95004a9c0134bb8962f2624dbc22160ea1028de804208d8779...
SHOW TABLES FROM `dbnrll`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:06:46.036298	2024-06-16 10:06:46.079573	8a478cca22d1e1395e17f4cd2d4e86835e166a28f625dedb6d...
SHOW TABLES FROM `diego naal`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:03:12.821666	2024-06-16 10:03:12.858483	7d08af4129205d83a4412d084629f1a96ae47b23c8e1054be2...
SHOW TABLES FROM `data4`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:07:13.236907	2024-06-16 10:07:13.292002	31e23c83f68d130d322e0ece8c321480a4b018ad2c5b7f66a4...
SHOW TABLES FROM `spksaw`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:03:25.479164	2024-06-16 10:06:36.635538	d50e129dd33313e725843f2b7c566a14dfef8c9ebec6fede0d...
SHOW TABLE STATUS FROM `spksaw` WHERE `Name` LIKE ...	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:03:25.537378	2024-06-16 10:06:36.714499	b676e361d95daacd65ed7a76fa06e31a753a7ba31e5338c013...
SHOW TABLES FROM `archery`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:07:54.871194	2024-06-16 10:07:54.926121	92a744dd2317efb852022e7bc6716959e60e1123b20f68f3d6...
SHOW TABLES FROM `amp`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:04.682505	2024-06-16 10:01:04.741712	edae63f8a9d52fb5ce61eebc6117c1e07d4df02290ad66fe74...
SHOW TABLES FROM `appbancaire`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:08:23.126780	2024-06-16 10:08:23.161960	9ee5d13a40290bc06e1f713e67a7ef7e73fa04d25442efc723...
SHOW TABLE STATUS FROM `demo1` WHERE `Name` LIKE ?	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:05.539223	2024-06-16 10:01:05.757661	f5f0e846aef4baa08f97a14870bae64d94094b8c407d705d26...
SHOW TABLES FROM `active_plugins`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:08:59.941858	2024-06-16 10:09:00.009601	bda8d643983d2c9aac41106d08a8e630477a13cf062d31b34e...
SELECT ? FROM `demo1` . `user` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:05.581251	2024-06-16 10:01:05.780928	d2e3685715cd248994cdd0354d9851c08c8f068b9b1742e135...
SHOW TABLES FROM `demo1`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:05.651580	2024-06-16 10:01:05.843300	6af7aa23ac2dceb2cd27ba001a46f75d9301b180b9294c22fc...
SHOW TABLES FROM `dgfj`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:05:25.638046	2024-06-16 10:05:25.695752	c54c5ee03bd7d84554818a10792ad2968efb13ed4a41e46ae8...
SHOW TABLES FROM `diplommonitoring`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:07.166806	2024-06-16 10:01:07.231650	dba448eb746efeb42b043eb2a746c90d74c328e0470ff14924...
SHOW TABLES FROM `deneveri`	NULL	2	2	100.0000	0	0.0000	2024-06-16 10:01:11.090646	2024-06-16 10:01:11.125471	318d67b77402d263c27db2fd7763403889fcbb1ccaca7c4c54...
SHOW FIELDS FROM `hit-db-demo` . `users`	hit-db-demo	2	2	100.0000	0	0.0000	2024-06-16 10:06:16.685913	2024-06-16 10:06:58.415334	cc20c2f4a734c60dd422ad8cde3e2df33fb706fd5f33f109f0...
SELECT ? FROM `hit-db-demo` . `users` LIMIT ?	hit-db-demo	43	2	4.6512	0	0.0000	2024-06-16 10:06:16.732623	2024-06-16 10:09:18.455233	1179f75d53666e9877a00ad13ca6434cc4f3972201d5f22412...
SELECT ? FROM `spksaw` . `hasil` LIMIT ?	NULL	1	1	100.0000	0	0.0000	2024-06-16 10:06:36.732718	2024-06-16 10:06:36.732718	282e9cd29ca17c31a5821533af65fa112d96a38a16664cc0d3...
SELECT ? FROM `hit-db-demo` . `users` LIMIT ?	NULL	5	1	20.0000	0	0.0000	2024-06-16 10:06:58.226616	2024-06-16 10:09:19.733994	1179f75d53666e9877a00ad13ca6434cc4f3972201d5f22412...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!