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.0048 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	1724	1724	100.0000	0	0.0000	2024-06-16 13:30:49.752379	2024-06-16 13:43:15.225531	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLES FROM `varshi`	NULL	18	18	100.0000	0	0.0000	2024-06-16 13:36:34.581069	2024-06-16 13:36:51.688435	a1c4a59978e2d8c8c9dbf988f53b5f894812d8a5ca90548d79...
SHOW FIELDS FROM `recruitment` . `recruitment_info...	mysql	9	9	100.0000	0	0.0000	2024-06-16 13:34:30.584708	2024-06-16 13:38:27.609686	07724206eda7b36b23ef18bba9bcd23ddb8ed2913feb4b0541...
SHOW FIELDS FROM `phpmyadmin` . `pma__designer_set...	mysql	9	9	100.0000	0	0.0000	2024-06-16 13:34:34.153363	2024-06-16 13:37:07.643693	70136581aa564742488557e39ab5691179bb204bc457217079...
SHOW TABLES FROM `recruitment`	mysql	9	9	100.0000	0	0.0000	2024-06-16 13:34:36.792615	2024-06-16 13:38:33.981792	33a4a1abc4a8a443ed8c982de109151c1b954849a8d8d39416...
SHOW FIELDS FROM `phpmyadmin` . `pma__navigationhi...	mysql	5	5	100.0000	0	0.0000	2024-06-16 13:36:17.036097	2024-06-16 13:36:22.049843	8a85099e1d143269b91a0f07e109bf42371b79320046007e14...
SHOW FIELDS FROM `phpmyadmin` . `pma__export_templ...	mysql	5	5	100.0000	0	0.0000	2024-06-16 13:36:25.849332	2024-06-16 13:37:01.794968	d861467ea1e9829caca84f4e90d49d829b2d131b521fa74623...
SHOW FIELDS FROM `phpmyadmin` . `pma__central_colu...	mysql	5	5	100.0000	0	0.0000	2024-06-16 13:37:08.657874	2024-06-16 13:37:14.030343	b492a1a1f7f0684860fdb9ffcf13c08e0d1e680e9c45ff7d44...
SHOW TABLES FROM `tbpenduduk`	NULL	4	4	100.0000	0	0.0000	2024-06-16 13:30:50.148125	2024-06-16 13:30:54.297104	d627515e2af9e086b106747011b4cbc0b85b18e07aaaf3eb57...
SHOW FIELDS FROM `phpmyadmin` . `pma__column_info`	mysql	4	4	100.0000	0	0.0000	2024-06-16 13:40:36.678596	2024-06-16 13:42:14.348894	95d3ceb8739213770e95283650878fba26cf4f817dd2d7349e...
SHOW FIELDS FROM `phpmyadmin` . `pma__savedsearche...	mysql	4	4	100.0000	0	0.0000	2024-06-16 13:41:52.842349	2024-06-16 13:41:55.641057	82983cfdb09822f231edeb7f28a20591af818b133ffaf45c8b...
SHOW FIELDS FROM `phpmyadmin` . `pma__table_uipref...	mysql	4	4	100.0000	0	0.0000	2024-06-16 13:42:01.788708	2024-06-16 13:42:04.897815	23b530d394acbb013ea2885f0143813eb96aa311e5934aa976...
SHOW TABLE STATUS FROM `phpmyadmin` WHERE `Name` L...	NULL	4	4	100.0000	0	0.0000	2024-06-16 13:36:24.816436	2024-06-16 13:37:10.682146	1485a11b8fa4b8366bc186f65e4e7fedf433367ec46a385ee2...
SHOW TABLES FROM `varshi`	mysql	4	4	100.0000	0	0.0000	2024-06-16 13:36:54.134890	2024-06-16 13:36:56.787725	a1c4a59978e2d8c8c9dbf988f53b5f894812d8a5ca90548d79...
SHOW FIELDS FROM `phpmyadmin` . `pma__table_coords...	mysql	3	3	100.0000	0	0.0000	2024-06-16 13:41:56.632062	2024-06-16 13:41:58.639330	37e31ee65b06710aa2dda832daad769e2a411a66e5b2fdca2f...
SHOW TABLES FROM `agenda`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:34:01.569257	2024-06-16 13:34:01.602873	6e8514cff4c32f09d67106ae90706e604a5465e13a7dbaf674...
SHOW TABLES FROM `Rohit`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:39:07.409718	2024-06-16 13:39:07.445628	920b5a947a70cf421ed966a8ae65563b54ba0fad5c0d965cc6...
SHOW TABLES FROM `ali 1`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:34:07.024178	2024-06-16 13:34:07.060250	983a48d308d96ce63ed24a7bb838bcebc6b8e15cdd2de59422...
SHOW TABLES FROM `data_studens`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:34:17.819695	2024-06-16 13:34:17.852956	6fae960d759a7a3a640734e5541892f2568128024c231645d9...
SHOW TABLES FROM `album`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:34:45.596107	2024-06-16 13:34:45.682456	e7785fe0793a45d8e831d376916b7ca5d27d632f2dd3fc9acd...
SHOW TABLE STATUS FROM `HR` WHERE `Name` LIKE ?	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:30:53.198355	2024-06-16 13:34:03.532014	416b6a152c83e623ae53317919368f7afba56e22b5f0f2e424...
SHOW TABLES FROM `dbsproject`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:35:09.344231	2024-06-16 13:35:09.378374	3c952495fac9f81d125a46d6c332af5c975a8dd11046105055...
SHOW FIELDS FROM `phpmyadmin` . `pma__bookmark`	mysql	2	2	100.0000	0	0.0000	2024-06-16 13:40:33.796465	2024-06-16 13:40:35.617083	586a34a1f7154ad19c198a9d721dabdc60d095b5b6fc626336...
SHOW TABLES FROM `dental`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:40:52.565308	2024-06-16 13:40:52.600941	dd30552fa95aa154ffe282bf8e7558e6447c4fa5d6bac8d91c...
SHOW TABLES FROM `dgfj`	NULL	2	2	100.0000	0	0.0000	2024-06-16 13:41:39.107501	2024-06-16 13:41:39.139874	c54c5ee03bd7d84554818a10792ad2968efb13ed4a41e46ae8...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!