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.0087 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	586	586	100.0000	0	0.0000	2024-06-21 07:15:47.210603	2024-06-21 07:18:28.103721	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `mysql_connect` WHERE `Name...	NULL	41	41	100.0000	0	0.0000	2024-06-21 07:15:51.491159	2024-06-21 07:17:05.766770	076bfc83b2b47391d5e5d8a6610a1abcda8cfe64e1036344eb...
SHOW FULL FIELDS FROM `mysql_connect` . `products`	NULL	38	38	100.0000	0	0.0000	2024-06-21 07:15:51.430197	2024-06-21 07:16:56.602904	f2cbf4728495a2fac804b47b7a3a118f40c9fbd5f5831c305b...
SELECT * FROM `mysql_connect` . `products` LIMIT ?	NULL	19	19	100.0000	0	0.0000	2024-06-21 07:15:51.431156	2024-06-21 07:16:56.603111	66b8d6d7811f40a1693ed21c4f30b66a1f524e9a1a3a473ea5...
SHOW CREATE TABLE `mysql_connect` . `products`	NULL	19	19	100.0000	0	0.0000	2024-06-21 07:15:51.431407	2024-06-21 07:16:56.603242	85fd1729c9b3e38ca7d475c0c41ac9a425fa4fe97973971410...
SELECT ? FROM `mysql_connect` . `products` LIMIT ?	NULL	19	19	100.0000	0	0.0000	2024-06-21 07:15:51.514697	2024-06-21 07:16:56.678355	fbf3e4547440252484808ff9b157569e24021c2b995eba130f...
SHOW FULL FIELDS FROM `mysql_connect` . `address`	NULL	18	18	100.0000	0	0.0000	2024-06-21 07:16:06.229615	2024-06-21 07:17:05.712938	198ada12b987f3b2b1dadd358b4cc24ca224a389c83714e68b...
SHOW FULL FIELDS FROM `mysql_connect` . `users`	NULL	16	16	100.0000	0	0.0000	2024-06-21 07:16:02.426840	2024-06-21 07:17:00.545255	e3a55186a39067f8ea7a7b4f9293d163ed975a3125e53eb95b...
SELECT * FROM `mysql_connect` . `address` LIMIT ?	NULL	9	9	100.0000	0	0.0000	2024-06-21 07:16:06.230503	2024-06-21 07:17:05.713115	0dea0b82f2c063e4bfe98b48966bf1f6ad74813fdc72428fa0...
SHOW CREATE TABLE `mysql_connect` . `address`	NULL	9	9	100.0000	0	0.0000	2024-06-21 07:16:06.230673	2024-06-21 07:17:05.713243	afdbb66ec673d11beee882c0b668f68219d4836b250ab1ab56...
SELECT ? FROM `mysql_connect` . `address` LIMIT ?	NULL	9	9	100.0000	0	0.0000	2024-06-21 07:16:06.337443	2024-06-21 07:17:05.788534	5c490533acf8a560927c53034b87cec76a542d4224cc59e561...
SELECT * FROM `mysql_connect` . `users` LIMIT ?	NULL	8	8	100.0000	0	0.0000	2024-06-21 07:16:02.428065	2024-06-21 07:17:00.545512	86c6820416a06278ae088f2b907eef2831107b442aee4120b8...
SHOW CREATE TABLE `mysql_connect` . `users`	NULL	8	8	100.0000	0	0.0000	2024-06-21 07:16:02.428306	2024-06-21 07:17:00.545685	073e869df1e2e3e54c46541d40943f6ca8c19829c9ef8bbede...
SELECT ? FROM `mysql_connect` . `users` LIMIT ?	NULL	8	8	100.0000	0	0.0000	2024-06-21 07:16:02.507507	2024-06-21 07:17:00.666027	f8252ddb7565cefd3babfaa8887940496e121744d609943fe5...
SHOW FULL FIELDS FROM `mysql_connect` . `order`	NULL	8	8	100.0000	0	0.0000	2024-06-21 07:16:13.253771	2024-06-21 07:16:17.852245	f4dc8e9908e20e3a1869aff781e88da87e4a818a525fd5a16b...
SHOW FULL FIELDS FROM `php` . `BCA`	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:15:47.214800	2024-06-21 07:15:47.398711	ee51df1aa1c4c8a14d3db43ff1bdea8e5f29db9f2acd0c45af...
SHOW TABLES FROM `php`	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:15:48.430832	2024-06-21 07:15:52.906528	ff9db9141878f12339794ec9d8604edc5b4d429abaedb6ee4c...
SHOW TABLES FROM `BCA6`	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:15:50.560115	2024-06-21 07:15:54.486445	384c909b46a1542c8f97acfa886290bdbe4610da2ec7e4d95d...
SELECT * FROM `mysql_connect` . `order` LIMIT ?	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:16:13.254709	2024-06-21 07:16:17.852580	4417dedf30a9fae84c4831bdd3d02a98bf270f9ffb3021e0bc...
SHOW CREATE TABLE `mysql_connect` . `order`	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:16:13.262097	2024-06-21 07:16:17.852889	6542e1873399e3c466bed7826e10679e04a77c5cdfd1d56bfc...
SELECT ? FROM `mysql_connect` . `order` LIMIT ?	NULL	4	4	100.0000	0	0.0000	2024-06-21 07:16:13.557822	2024-06-21 07:16:17.949337	3e541f3f6a2e37581f0456e896107c7c999f318825a29c2985...
SHOW TABLE STATUS FROM `php` WHERE `Name` LIKE ?	NULL	3	3	100.0000	0	0.0000	2024-06-21 07:15:47.292783	2024-06-21 07:15:49.298270	2c8eb2ef87c92d46ac19117ed1df7eceb72f484bfdde09f8f8...
SELECT ? FROM `php` . `BCA` LIMIT ?	NULL	3	3	100.0000	0	0.0000	2024-06-21 07:15:47.316080	2024-06-21 07:15:49.319311	4857b0eb806dd3909e9a524b24c0ef6a972b68abdef341f06d...
SELECT * FROM `php` . `BCA` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-06-21 07:15:47.216245	2024-06-21 07:15:47.398918	75ea24218dda388f002d48ef175e94f46b62aa7b727a51150a...
SHOW CREATE TABLE `php` . `BCA`	NULL	2	2	100.0000	0	0.0000	2024-06-21 07:15:47.216448	2024-06-21 07:15:47.399077	eef15e2070919f428eea1d25ef17c8933c53342dfb9413492e...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!