demo.phpmyadmin.net / phpMyAdmin demo - MySQL / sys / 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.0127 seconds.)

SELECT * FROM `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	2063	2063	100.0000	0	0.0000	2024-06-16 14:30:55.720792	2024-06-16 14:44:56.422516	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLES FROM `FacultyDB`	NULL	8	8	100.0000	0	0.0000	2024-06-16 14:41:51.543304	2024-06-16 14:43:04.656282	e591b734ff720cd41727e0cc4c6d4881538f2492d63ac9fa96...
SHOW TABLES FROM `магазин123`	NULL	7	7	100.0000	0	0.0000	2024-06-16 14:41:46.510335	2024-06-16 14:43:04.058163	a4439a1d2daea843061e893b2c554c92b5d2905ec7bf6d3325...
SELECT COUNT ( * ) FROM `sakila` . `f`	sakila	3	3	100.0000	0	0.0000	2024-06-16 14:44:43.155459	2024-06-16 14:44:43.177062	3f70dc0253b8c77b936c819e915ddb3300c2d9be6c268cb38f...
SHOW TABLES FROM `txt`	NULL	3	3	100.0000	0	0.0000	2024-06-16 14:35:56.168805	2024-06-16 14:36:51.136000	d7778c88ea7fd332434312f8ea8e93f85ed8bd2c0cfed75557...
SHOW TABLES FROM `123`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:44:29.151127	2024-06-16 14:44:29.211804	afc84537a120ab7df7eb2e1dfa7e52890af9cbfe7294b9e64d...
SHOW TABLES FROM `dgfj`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:39:06.106626	2024-06-16 14:39:06.144684	c54c5ee03bd7d84554818a10792ad2968efb13ed4a41e46ae8...
SHOW TABLES FROM `articles`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:36:50.820948	2024-06-16 14:36:50.856023	1d704666a7d58b8bf45861abdd11a6381695c6f40a59e3565d...
SHOW TABLES FROM `MainLogs`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:39:09.147908	2024-06-16 14:39:09.196266	2d93a33f78aaea7c20cd0e0a1b0abc7f094b0583e38b70aa20...
SHOW TABLES FROM `training`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:33:33.706414	2024-06-16 14:33:33.750189	00ba71d73cef597556d2b8da7df409825e1170ac7593bbedaa...
SHOW TABLES FROM `dbregistration`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:33:37.174529	2024-06-16 14:33:37.249832	e0db13c6adcbcf3983939c304af7833fa965880bcc951d6454...
SHOW TABLES FROM `ankita`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:39:15.598626	2024-06-16 14:39:15.649859	bdf105070a32b8288b1dd66a8d132bc3efce06de2f46dc743a...
SHOW TABLES FROM `adatok`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:37:08.110546	2024-06-16 14:37:08.171790	d996a033a0a692ef24b4fb05fd6ca0c97859293a8783d9bf72...
SHOW TABLES FROM `AssetsDB`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:30:58.019270	2024-06-16 14:30:58.052794	6bbef9e4be2d8ad58fd34d71e39f95a53f43f8ff3d3c52b9ce...
SHOW TABLES FROM `airlinedata`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:34:59.420416	2024-06-16 14:34:59.455084	8053304724238505322367e48d04512640dabb8b0f9605d95d...
SHOW TABLES FROM `detak_jantung`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:32:02.273121	2024-06-16 14:32:02.307952	378b0f878ab29b340587dae634ba5992a18c23d883aaa33400...
SHOW TABLES FROM `put`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:41:18.124930	2024-06-16 14:41:18.181240	d7d8ed7d90b3cdf7c75842a8e9f4b202b7347207443fadc26e...
SHOW TABLES FROM `магазин`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:41:53.954501	2024-06-16 14:41:54.823150	b206d7008aa4f0c1f6a87896c4595d6e0da282ea3729dffc52...
SHOW TABLES FROM `kelompok 6`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:31:01.560536	2024-06-16 14:40:15.308356	98e80b657e0680fd9a1ba9477b762f4a25f844028c57d07093...
SHOW TABLES FROM `armannn`	NULL	2	2	100.0000	0	0.0000	2024-06-16 14:41:55.682322	2024-06-16 14:41:56.743920	3456b028de558e4841138e57ed16af7b4701554e4b38badea1...
SHOW TABLES FROM `ACTIVIDAD`	NULL	1	1	100.0000	0	0.0000	2024-06-16 14:44:00.913024	2024-06-16 14:44:00.913024	88f36ea7b61acb08dfed73c5e6eb25d7c904c24904f67d733f...
SHOW TABLES FROM `datos`	NULL	1	1	100.0000	0	0.0000	2024-06-16 14:44:06.736774	2024-06-16 14:44:06.736774	d55fb41d056af74372895cfcf28f88d583904de607a4135b65...
SHOW TABLES FROM `maman`	NULL	1	1	100.0000	0	0.0000	2024-06-16 14:36:30.087810	2024-06-16 14:36:30.087810	1bddabca3fa507f8997b48dffdf0a39d202d73df2f3480ac87...
SHOW TABLES FROM `Banka`	NULL	1	1	100.0000	0	0.0000	2024-06-16 14:38:25.750251	2024-06-16 14:38:25.750251	80ad1f958c7b5981e25eb39a9fe93c26d50262d385d535e33e...
SHOW TABLES FROM `Dulce`	NULL	1	1	100.0000	0	0.0000	2024-06-16 14:36:31.320926	2024-06-16 14:36:31.320926	21d0bf8a439c55157c3db76cb430c6b663a93d39b2ed668274...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!