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.

Your SQL query has been executed successfully.

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	2988	2988	100.0000	0	0.0000	2025-01-06 13:01:02.318750	2025-01-06 13:12:29.252151	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLES FROM `Wow`	NULL	79	79	100.0000	0	0.0000	2025-01-06 13:01:02.803595	2025-01-06 13:08:34.483768	4a3ba8ff08ad29bcdd71c4bbd9c690089ad5b9154f5598cbbb...
SHOW TABLES FROM `train`	NULL	63	63	100.0000	0	0.0000	2025-01-06 13:01:52.920679	2025-01-06 13:08:56.980776	327396c4fe457955e381914353284a128fa0d5f60a7f7a0523...
SHOW TABLES FROM `music`	NULL	32	32	100.0000	0	0.0000	2025-01-06 13:01:48.007089	2025-01-06 13:08:49.548021	196d59cd4c02bd439c43ed165e63419628dba258509439f145...
SHOW TABLE STATUS FROM `sakila` WHERE `Name` LIKE ...	NULL	31	31	100.0000	0	0.0000	2025-01-06 13:07:24.176142	2025-01-06 13:11:56.948667	4f604bda5381e43a55ae4d5b97d5b9b7eef3814c27f46ecb93...
SHOW TABLE STATUS FROM ` ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВО...	NULL	24	24	100.0000	0	0.0000	2025-01-06 13:08:22.524227	2025-01-06 13:12:22.378008	89142ce89ffd61eea3fe3b28e84270f66586b387ab2dbb02a5...
SHOW TABLE STATUS FROM `rpg` WHERE `Name` LIKE ?	NULL	23	23	100.0000	0	0.0000	2025-01-06 13:01:02.575523	2025-01-06 13:12:23.153017	f13d89d51a7fdaafe8c2f20ef17367aa76761c7fd642491ddb...
SELECT ? FROM ` ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ` . .....	NULL	21	21	100.0000	0	0.0000	2025-01-06 13:08:22.527375	2025-01-06 13:12:22.384618	a818875eb7c802f8b815256e5c66981954b63abdd9e4173ae5...
SHOW TABLES FROM `22ucs35`	NULL	16	16	100.0000	0	0.0000	2025-01-06 13:07:17.826339	2025-01-06 13:07:52.946081	36e88d2ffa5434097e43db11cd97755ef3b9aeef04fb696a22...
SHOW TABLES FROM `sneha`	NULL	14	14	100.0000	0	0.0000	2025-01-06 13:02:26.957352	2025-01-06 13:03:48.940830	0a628075a98c3b758cd33faa365840c1920f546f7627ddd201...
SHOW TABLE STATUS FROM `testei` WHERE `Name` LIKE ...	NULL	12	12	100.0000	0	0.0000	2025-01-06 13:09:17.051066	2025-01-06 13:12:25.732154	334e5ce381bc0b3c31f9fadc0d5bdca4974bc3aa85379f4f9e...
SELECT ? FROM `sakila` . `film` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2025-01-06 13:07:34.229076	2025-01-06 13:10:50.789321	3aee09d8f6b4d1def813ef0417f3f977f1c24ac96b55120e63...
SHOW TABLES FROM `Moha`	NULL	12	12	100.0000	0	0.0000	2025-01-06 13:01:13.210303	2025-01-06 13:07:58.919897	0821b070e4d3c4bdce3ff0e18dbf665ab8a0d85a65f2df70a0...
SHOW TABLES FROM `db_kelbak`	NULL	11	11	100.0000	0	0.0000	2025-01-06 13:01:08.339578	2025-01-06 13:07:26.072919	9ed341164aebd4e84b42c74e605438c80bc79cbc19537b90b5...
SELECT ? FROM `sakila` . `inventory` LIMIT ?	NULL	11	11	100.0000	0	0.0000	2025-01-06 13:07:50.030401	2025-01-06 13:11:56.951857	b6fd5633f47add99309ae0b50bceae06fcff76c924d40c58f2...
SELECT ? FROM `ders` . `atauni` LIMIT ?	ders	11	11	100.0000	0	0.0000	2025-01-06 13:07:57.067754	2025-01-06 13:11:37.728105	65cce359a41f93cf64633e1c00c2a9d534544a3d543beae7ff...
SHOW TABLES FROM `Kredit`	NULL	10	10	100.0000	0	0.0000	2025-01-06 13:01:11.358862	2025-01-06 13:11:28.565888	440739813b742e0024d1396e610fd9586fbafd44236b64351b...
SHOW TABLES FROM `Loan_ApplicationDB`	NULL	9	9	100.0000	0	0.0000	2025-01-06 13:03:05.310715	2025-01-06 13:12:07.508554	8bca8a60d97cfccba6aceb1ab0107c994c4ec3943a7a58d6ff...
SHOW TABLES FROM `ahmad.com`	NULL	9	9	100.0000	0	0.0000	2025-01-06 13:01:06.468952	2025-01-06 13:10:39.130310	1636f2691ecc0a635048f51c2d96a51a8de8f72bae7349e36d...
SHOW FIELDS FROM `ders` . `atauni`	ders	9	9	100.0000	0	0.0000	2025-01-06 13:07:57.046296	2025-01-06 13:11:37.722569	310f84c97842339e2f1beda67a241470dcdd813c2c8cd47b72...
SHOW TABLES FROM `simpanpinjam`	NULL	8	8	100.0000	0	0.0000	2025-01-06 13:01:03.104675	2025-01-06 13:09:27.114583	0c5b3345e7dc430989ebbc0068176d2d2f305d753149d5787f...
SHOW TABLES FROM `Travel_agencyBase`	NULL	8	8	100.0000	0	0.0000	2025-01-06 13:01:40.442014	2025-01-06 13:09:55.286243	ff70c0c5dc8f24235f4c4348af33ebc09fbba22fdb2a6d571a...
SHOW TABLE STATUS FROM `rq` WHERE `Name` LIKE ?	NULL	7	7	100.0000	0	0.0000	2025-01-06 13:01:03.090766	2025-01-06 13:11:16.879330	b9be323d6079f1ba73484943aa18918b980794998117dc5535...
SELECT ? FROM `ders` . `atauni` LIMIT ?	NULL	7	7	100.0000	0	0.0000	2025-01-06 13:10:13.470362	2025-01-06 13:11:37.522683	65cce359a41f93cf64633e1c00c2a9d534544a3d543beae7ff...
SHOW TABLE STATUS FROM `azin` WHERE `Name` LIKE ?	NULL	7	7	100.0000	0	0.0000	2025-01-06 13:10:49.309868	2025-01-06 13:11:28.069126	af335d857ad6531f35f37aa83f1269847d07984f1c1e74b7ae...

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.