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	2159	2159	100.0000	0	0.0000	2026-03-31 03:15:54.129457	2026-03-31 03:25:21.801094	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SELECT ? FROM `student_db` . `students` LIMIT ?	NULL	23	23	100.0000	0	0.0000	2026-03-31 03:16:04.743290	2026-03-31 03:19:31.889035	318b1795058bdeabb65158f20e719d4ba1712e5d7f16276142...
SHOW TABLES FROM `student_db`	NULL	7	7	100.0000	0	0.0000	2026-03-31 03:16:05.843418	2026-03-31 03:16:29.266165	4e00421e821f178fdfe6917fabe638f7dcd9eadd95be434ef8...
SELECT COUNT ( * ) FROM `sakila` . `f`	sakila	6	6	100.0000	0	0.0000	2026-03-31 03:21:06.411437	2026-03-31 03:25:06.728392	3f70dc0253b8c77b936c819e915ddb3300c2d9be6c268cb38f...
SHOW TABLES FROM `CWMS`	NULL	5	5	100.0000	0	0.0000	2026-03-31 03:18:03.973307	2026-03-31 03:19:28.122369	cca99b9a0bf828f9be1af97afff4aadfc242bba126f0e5a2ba...
SELECT ? FROM `student_db` . `students` LIMIT ?	student_db	31	5	16.1290	0	0.0000	2026-03-31 03:17:10.799661	2026-03-31 03:25:15.326536	318b1795058bdeabb65158f20e719d4ba1712e5d7f16276142...
SHOW TABLES FROM `libraryDB`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:16:07.721054	2026-03-31 03:16:08.854762	9eaa39497fe40b735d3226d5518d0276c3a4fe150411520f79...
SELECT ? FROM `Perpustakaan` . `users` LIMIT ?	NULL	5	4	80.0000	0	0.0000	2026-03-31 03:18:15.404431	2026-03-31 03:21:14.515042	93deade44c89d2e6c979d97544120422753858210ebb474905...
SHOW TABLES FROM `escuela`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:18:39.653494	2026-03-31 03:18:40.368620	bf2760fc284e763b6c04ed482662c4f07fe0b6f0b581c854ec...
SHOW TABLES FROM `Banco_do_Epstein`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:18:46.515816	2026-03-31 03:18:46.896677	732223eccb88ce7322d0768c394a0a9926dcb50356320b0e21...
SHOW TABLES FROM `ATM`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:16:05.225736	2026-03-31 03:24:26.948954	c01e0c82f63b5f14329209b4f17337672e97ef7945f94c7f0b...
SHOW TABLES FROM `DULIEU`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:16:51.523124	2026-03-31 03:18:15.094321	43af5cf2e9ff7ef040e918eb4d8639d89a455008bf776b0382...
SHOW TABLES FROM `BooksNet`	NULL	4	4	100.0000	0	0.0000	2026-03-31 03:19:38.165302	2026-03-31 03:23:36.743028	9c4bb3cfca9d4fd11672fb1dd84b6610606f0da5e6cb7f042a...
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE...	NULL	701	3	0.4280	0	0.0000	2026-03-31 03:15:55.889641	2026-03-31 03:25:21.545600	10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c...
SHOW TABLES FROM `milena`	NULL	3	3	100.0000	0	0.0000	2026-03-31 03:19:26.207202	2026-03-31 03:21:30.114303	617d81dfda3683a1a01e315cb60da10f2a92ae8da81d29f2a9...
SELECT ? FROM `INFORMATION_SCH ... ser` AND ? LIKE...	NULL	16	3	18.7500	0	0.0000	2026-03-31 03:16:06.081519	2026-03-31 03:24:55.563942	2c1d854eee39224e5fcace996a044c9d7b1a5c62507f079689...
SHOW FIELDS FROM `student_db` . `students`	student_db	3	3	100.0000	0	0.0000	2026-03-31 03:17:10.774723	2026-03-31 03:19:32.100584	a1994ecb42212283f3657826262be58b20f2a40f8ac131d002...
SHOW TABLES FROM `tienda2`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:23:46.990210	2026-03-31 03:23:47.011400	b80174990392575f17dc5155638784008e0ba12ffc80d97e85...
SHOW TABLES FROM `dane`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:24:02.871448	2026-03-31 03:24:02.888636	260e93c30dc488a11918508fb614bab80ee1972077717fbe86...
SHOW TABLES FROM `taxi`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:16:09.945024	2026-03-31 03:16:09.961672	0bb9df53b374fdc344f075e5e101d45832d7ab3cddfe679429...
SHOW TABLES FROM `kozvetito`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:20:34.465228	2026-03-31 03:20:34.475278	f8a4455580e4b19416f46e58bc30ddd1733b2773eaf1b215d1...
SHOW FIELDS FROM `perpustakaan` . `users`	perpustakaan	2	2	100.0000	0	0.0000	2026-03-31 03:20:34.963708	2026-03-31 03:24:52.820709	4272220da1d54e72f29651b0b0724d561386e57b11382ef647...
SELECT ? FROM `perpustakaan` . `users` LIMIT ?	perpustakaan	6	2	33.3333	0	0.0000	2026-03-31 03:20:34.995696	2026-03-31 03:24:53.431598	dcb73c5c9813b5cb81aca428cfc485fed4e654f036ee1872a8...
SHOW TABLES FROM `perpustakaan`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:18:40.807720	2026-03-31 03:20:10.137222	2ca11486cee7c90507565d5632ec7cfed46505d572ba0ca024...
SHOW TABLES FROM `pichau`	NULL	2	2	100.0000	0	0.0000	2026-03-31 03:18:41.573388	2026-03-31 03:18:41.597158	0fff4b069445ebeefd6dcc79c8f8673fa79c2259dca28a6a15...

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.