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.

Your SQL query has been executed successfully.

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	401	401	100.0000	0	0.0000	2025-07-03 06:01:01.557729	2025-07-03 06:05:39.750055	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SELECT ? FROM `library_PSS` . `bookinfo` LIMIT ?	NULL	5	5	100.0000	0	0.0000	2025-07-03 06:01:05.972735	2025-07-03 06:05:17.225624	49d31fdcf6b3c9c5a895c06484276b3b6ae7de43d8b87fb7a7...
SHOW TABLES FROM `library_PSS`	NULL	4	4	100.0000	0	0.0000	2025-07-03 06:01:05.734902	2025-07-03 06:01:37.119908	9d2ba28e8f2c2260531243b65c2d9ab666f954d993228bb53c...
SHOW TABLES FROM `blog`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:04:53.320287	2025-07-03 06:04:53.337425	94f9aa8512d48464f394a886139562d19eaaedea58167eb88f...
SHOW TABLES FROM `alfamart`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:01:05.840160	2025-07-03 06:01:05.885050	d74276693c44133bf0cbf5f55bf45451bdf425e256c21b104d...
SHOW TABLES FROM `tiyabd`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:01:05.875697	2025-07-03 06:01:05.926453	1c1f2e5b8f5d56d46fcef4ecd6a6872c5d2b473d875e3d0706...
SHOW TABLE STATUS FROM `library_PSS` WHERE `Name` ...	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:05:16.982222	2025-07-03 06:05:17.222415	5481d5abb3a31866b1ed0bb9e398196a545acc7a42b5cc4a73...
SHOW TABLES FROM `sumera6`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:01:06.057521	2025-07-03 06:01:06.096736	679dd5adf43384142d04f044a29473a4a82cc4b5c52c92f9ac...
SHOW TABLES FROM `transpog`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:01:06.098069	2025-07-03 06:01:06.118548	62094bf07544a8925c3f39edb3db12cc2eeef2d2cca1eff226...
SHOW TABLES FROM `B`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:02:17.486076	2025-07-03 06:02:17.502175	565297c07dc7ee943c65a226fbd7901d5fe43659182005c59d...
SHOW TABLES FROM `AAA`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:02:56.466187	2025-07-03 06:02:56.475425	a3992b5090b1ba6451e7a45760e96d4fc9eea2cd6f5a889131...
SHOW TABLES FROM `ayanali`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:02:56.741350	2025-07-03 06:02:56.751685	f1a1aacf6850c36fbd34afae3667506d44905fe8d33faf7322...
SHOW TABLES FROM `vidhitakoli`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:03:37.984617	2025-07-03 06:03:38.002845	84f8159ac173e406ad26dc6cd869a0356b8de156a1bf38c78d...
SHOW TABLES FROM `BBB`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:03:37.996124	2025-07-03 06:03:38.012903	7b4c77b437d7caeb50e5097d47b40aab5a12e177da6fc81ad0...
SHOW TABLES FROM `vendor`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:04:14.800896	2025-07-03 06:04:14.816107	5abcc4560c5a8be00f2d6fafcc50efce9a49a018628b34ab9e...
SHOW TABLES FROM `xyz`	NULL	2	2	100.0000	0	0.0000	2025-07-03 06:04:14.800974	2025-07-03 06:04:14.814656	9f0e67a6c1830a29b8bbc5b0c78d2e030906d980859639ab9c...
SHOW TABLES FROM `Proveedoorr`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:04:14.823576	2025-07-03 06:04:14.823576	686b491f76a1b45d3fe8f12f1dd020f194aa9e993e8168f59a...
SHOW TABLES FROM `reservasi16`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:04:24.140459	2025-07-03 06:04:24.140459	cda0a6df17f93e282cfd13f82aade290b505ef28402fe4db6f...
SHOW TABLES FROM `Tipo_Base_adrian`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:04:26.935167	2025-07-03 06:04:26.935167	6c95f5694a193c931caf7579fdbfd5e192f48e257a710734de...
SHOW TABLES FROM `NKNKNK`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:04:27.573999	2025-07-03 06:04:27.573999	ea2d6dc9411e6d7f020d81b3d3e65a526d90ca2ee0d667eb85...
SHOW TABLES FROM `logeo`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:04:55.882364	2025-07-03 06:04:55.882364	171a9641fa87c4c666d82d7ff58e93c0ebbd59c59d53809a29...
SHOW TABLES FROM `Mini-Sistema`	NULL	1	1	100.0000	0	0.0000	2025-07-03 06:05:23.902262	2025-07-03 06:05:23.902262	25d60104f711dd5e920d71eb8335058cd227f92a94e76e2adb...
SHOW FIELDS FROM `library_PSS` . `bookinfo`	library_PSS	1	1	100.0000	0	0.0000	2025-07-03 06:05:38.227646	2025-07-03 06:05:38.227646	1d7ad47388d33a3e8ab6609e999bfbe1a68fd9e2f0a8e18d12...
SHOW FULL FIELDS FROM `library_PSS` . `bookinfo`	library_PSS	1	1	100.0000	0	0.0000	2025-07-03 06:05:38.228100	2025-07-03 06:05:38.228100	d1d5c42f6bda5c2ce89decbbfa3a20748bb8342f9e4d160835...
SHOW CREATE TABLE `library_PSS` . `bookinfo`	library_PSS	1	1	100.0000	0	0.0000	2025-07-03 06:05:38.228511	2025-07-03 06:05:38.228511	e1868d4439bfe40129f0dfdab3a7e307e244b26bc32303a9cd...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-5377-g8e721911f0 from the master branch.