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.0073 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	2070	2070	100.0000	0	0.0000	2024-06-21 07:15:47.210603	2024-06-21 07:25:50.974640	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `mysql_connect` WHERE `Name...	NULL	91	91	100.0000	0	0.0000	2024-06-21 07:15:51.491159	2024-06-21 07:23:26.276018	076bfc83b2b47391d5e5d8a6610a1abcda8cfe64e1036344eb...
SHOW FULL FIELDS FROM `mysql_connect` . `products`	NULL	74	74	100.0000	0	0.0000	2024-06-21 07:15:51.430197	2024-06-21 07:23:16.574208	f2cbf4728495a2fac804b47b7a3a118f40c9fbd5f5831c305b...
SELECT ? FROM `mysql_connect` . `products` LIMIT ?	NULL	38	38	100.0000	0	0.0000	2024-06-21 07:15:51.514697	2024-06-21 07:23:16.670710	fbf3e4547440252484808ff9b157569e24021c2b995eba130f...
SELECT * FROM `mysql_connect` . `products` LIMIT ?	NULL	37	37	100.0000	0	0.0000	2024-06-21 07:15:51.431156	2024-06-21 07:23:16.574352	66b8d6d7811f40a1693ed21c4f30b66a1f524e9a1a3a473ea5...
SHOW CREATE TABLE `mysql_connect` . `products`	NULL	37	37	100.0000	0	0.0000	2024-06-21 07:15:51.431407	2024-06-21 07:23:16.574462	85fd1729c9b3e38ca7d475c0c41ac9a425fa4fe97973971410...
SHOW FULL FIELDS FROM `mysql_connect` . `users`	NULL	36	36	100.0000	0	0.0000	2024-06-21 07:16:02.426840	2024-06-21 07:23:26.204407	e3a55186a39067f8ea7a7b4f9293d163ed975a3125e53eb95b...
SHOW FULL FIELDS FROM `mysql_connect` . `address`	NULL	30	30	100.0000	0	0.0000	2024-06-21 07:16:06.229615	2024-06-21 07:20:36.523905	198ada12b987f3b2b1dadd358b4cc24ca224a389c83714e68b...
SHOW FULL FIELDS FROM `mysql_connect` . `order`	NULL	24	24	100.0000	0	0.0000	2024-06-21 07:16:13.253771	2024-06-21 07:23:07.584216	f4dc8e9908e20e3a1869aff781e88da87e4a818a525fd5a16b...
SELECT ? FROM `mysql_connect` . `users` LIMIT ?	NULL	19	19	100.0000	0	0.0000	2024-06-21 07:16:02.507507	2024-06-21 07:23:26.314483	f8252ddb7565cefd3babfaa8887940496e121744d609943fe5...
SELECT * FROM `mysql_connect` . `users` LIMIT ?	NULL	18	18	100.0000	0	0.0000	2024-06-21 07:16:02.428065	2024-06-21 07:23:26.204797	86c6820416a06278ae088f2b907eef2831107b442aee4120b8...
SHOW CREATE TABLE `mysql_connect` . `users`	NULL	18	18	100.0000	0	0.0000	2024-06-21 07:16:02.428306	2024-06-21 07:23:26.205089	073e869df1e2e3e54c46541d40943f6ca8c19829c9ef8bbede...
SELECT ? FROM `mysql_connect` . `address` LIMIT ?	NULL	16	16	100.0000	0	0.0000	2024-06-21 07:16:06.337443	2024-06-21 07:22:53.774023	5c490533acf8a560927c53034b87cec76a542d4224cc59e561...
SELECT * FROM `mysql_connect` . `address` LIMIT ?	NULL	15	15	100.0000	0	0.0000	2024-06-21 07:16:06.230503	2024-06-21 07:20:36.524182	0dea0b82f2c063e4bfe98b48966bf1f6ad74813fdc72428fa0...
SHOW CREATE TABLE `mysql_connect` . `address`	NULL	15	15	100.0000	0	0.0000	2024-06-21 07:16:06.230673	2024-06-21 07:20:36.524370	afdbb66ec673d11beee882c0b668f68219d4836b250ab1ab56...
SELECT ? FROM `mysql_connect` . `order` LIMIT ?	NULL	13	13	100.0000	0	0.0000	2024-06-21 07:16:13.557822	2024-06-21 07:23:07.668452	3e541f3f6a2e37581f0456e896107c7c999f318825a29c2985...
SELECT * FROM `mysql_connect` . `order` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-06-21 07:16:13.254709	2024-06-21 07:23:07.584462	4417dedf30a9fae84c4831bdd3d02a98bf270f9ffb3021e0bc...
SHOW CREATE TABLE `mysql_connect` . `order`	NULL	12	12	100.0000	0	0.0000	2024-06-21 07:16:13.262097	2024-06-21 07:23:07.584689	6542e1873399e3c466bed7826e10679e04a77c5cdfd1d56bfc...
SHOW FULL FIELDS FROM `mysql_connect` . `korzina`	NULL	8	8	100.0000	0	0.0000	2024-06-21 07:16:12.750644	2024-06-21 07:23:01.446957	68ebe5eb5cc9a357d4e10901c5f631da68e4f48d6a1b6d0f3e...
SHOW FULL FIELDS FROM `apple` . `agent_table`	NULL	6	6	100.0000	0	0.0000	2024-06-21 07:23:53.534706	2024-06-21 07:23:55.720985	1c59a66085faabdce8d4edffdae590900aaf71c6c82af990f9...
SHOW TABLES FROM `kono`	NULL	6	6	100.0000	0	0.0000	2024-06-21 07:19:07.920914	2024-06-21 07:21:30.250445	35b6f7279d2ff5d0df82ec19431eb6a42b74270b318769b8ae...
SELECT ? FROM `mysql_connect` . `korzina` LIMIT ?	NULL	5	5	100.0000	0	0.0000	2024-06-21 07:16:12.859987	2024-06-21 07:23:01.521283	7190588704eeae020cb472739b912a90690b22b7d12bd92151...
SHOW TABLES FROM `local-host`	NULL	5	5	100.0000	0	0.0000	2024-06-21 07:16:34.043269	2024-06-21 07:22:44.013033	b64f821db18321364ca4c2861ccafdc14d105cd90596d249da...
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...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!