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.0039 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	1456	1456	100.0000	0	0.0000	2024-06-28 18:00:54.834809	2024-06-28 18:04:05.310759	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `tavsancity` WHERE `Name` L...	NULL	132	132	100.0000	0	0.0000	2024-06-28 18:01:05.903842	2024-06-28 18:03:17.940278	e1b8b5e454957700e0ee734d98ce4b8a47d87d8cd613c4e922...
SHOW TABLES FROM `health_food_advisor`	NULL	32	32	100.0000	0	0.0000	2024-06-28 18:01:00.252386	2024-06-28 18:03:15.530418	bdaacca4e447ca4647ba43be090b94441d070239f47e9d980f...
SHOW TABLE STATUS FROM `health_food_advisor` WHERE...	NULL	21	21	100.0000	0	0.0000	2024-06-28 18:01:00.328733	2024-06-28 18:02:31.687522	b500698de1a7d55237d6254c1334a808017f3ebaa5b7d55373...
SHOW TABLE STATUS FROM `hotel` WHERE `Name` LIKE ?	NULL	19	19	100.0000	0	0.0000	2024-06-28 18:01:05.462680	2024-06-28 18:03:44.696791	5fdd2f4fd658f09a1774d9c7ca22ee865c119b0eff5b75de11...
SELECT ? FROM `tavsancity` . `logins` LIMIT ?	NULL	17	17	100.0000	0	0.0000	2024-06-28 18:01:06.041060	2024-06-28 18:02:35.614223	e045780352535c559744d96ee2019bd5c035239acab502281b...
SELECT ? FROM `tavsancity` . `errors` LIMIT ?	NULL	17	17	100.0000	0	0.0000	2024-06-28 18:01:06.121905	2024-06-28 18:02:27.600758	5716e2680774e2c48f60a740f7a27b3dd2309232b7d804fd15...
SELECT ? FROM `tavsancity` . `admins` LIMIT ?	NULL	17	17	100.0000	0	0.0000	2024-06-28 18:01:06.243996	2024-06-28 18:02:28.761559	4d0c0f0b70daa3cd35b0c1258060621275d8d50e40802dbf04...
SELECT ? FROM `tavsancity` . `users` LIMIT ?	NULL	16	16	100.0000	0	0.0000	2024-06-28 18:01:17.075176	2024-06-28 18:02:50.347142	d4b2599d834b5a6232846cec53ea45410188ede2cb14f062d5...
SHOW TABLES FROM `tavsancity`	NULL	16	16	100.0000	0	0.0000	2024-06-28 18:01:23.028587	2024-06-28 18:03:19.561805	231bcad72fc613cd18aef6d8cd46f0d0a291c596cc8c1e7673...
SELECT ? FROM `health_food_advisor` . `contacts` L...	NULL	15	15	100.0000	0	0.0000	2024-06-28 18:01:00.348562	2024-06-28 18:02:54.228095	a6b4586ff3e376036656ecff62ee41084ce9c122d4e4840241...
SELECT ? FROM `tavsancity` . `logs` LIMIT ?	NULL	15	15	100.0000	0	0.0000	2024-06-28 18:01:25.100927	2024-06-28 18:02:43.346635	cc15e19b216a7742ebd0ef2c63dc3159c5e1cd9c85f8152608...
SHOW TABLE STATUS FROM `health` WHERE `Name` LIKE ...	NULL	14	14	100.0000	0	0.0000	2024-06-28 18:03:35.014063	2024-06-28 18:03:53.035958	b438c35b758528f83fe7d0038290f82d918dab35fa5ccc7241...
SELECT ? FROM `tavsancity` . `vip` LIMIT ?	NULL	13	13	100.0000	0	0.0000	2024-06-28 18:01:14.518985	2024-06-28 18:03:07.374590	dbb51b1295e431fa8e36cb30dd0f2532213a9fe86fa9638562...
SELECT ? FROM `tavsancity` . `warnings` LIMIT ?	NULL	13	13	100.0000	0	0.0000	2024-06-28 18:01:33.404390	2024-06-28 18:03:13.843319	c8ddebd2b1d362e0aa51c509f3937beeacb7ad2c2d39c10156...
SELECT ? FROM `health` . `recommendations` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-06-28 18:03:35.036446	2024-06-28 18:03:53.070713	fe0d29207c974ac810b1bdb562e874c12d0a48fceaf0352aa5...
SELECT ? FROM `tavsancity` . `useractions` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-06-28 18:01:19.050661	2024-06-28 18:03:17.958665	075c39961f59ddc48f2bf3ebb25eb2faa34c5aaa2a4386951d...
SHOW TABLE STATUS FROM `lotesautos` WHERE `Name` L...	NULL	11	11	100.0000	0	0.0000	2024-06-28 18:00:54.892072	2024-06-28 18:01:02.392447	b2eef6840c5b8d6ccce71fb7cf91625128bc9a40bc23052416...
SELECT ? FROM `lotesautos` . `productos` LIMIT ?	NULL	11	11	100.0000	0	0.0000	2024-06-28 18:00:54.911927	2024-06-28 18:01:02.425251	171ec6aa00c0280f5791b4841c4ad920bab818c9476699a9b4...
SHOW TABLE STATUS FROM `loteautos` WHERE `Name` LI...	NULL	11	11	100.0000	0	0.0000	2024-06-28 18:03:51.042232	2024-06-28 18:04:04.694576	c22a293acf40b914f6f88f59c49c756717ac0963240314df12...
SELECT ? FROM `loteautos` . `productos` LIMIT ?	NULL	11	11	100.0000	0	0.0000	2024-06-28 18:03:51.081741	2024-06-28 18:04:04.715693	ce9be8253fa61558b13544cee6a8c2a0514b0d9b4b8cb0ab7a...
SHOW TABLES FROM `loteautos`	NULL	9	9	100.0000	0	0.0000	2024-06-28 18:00:58.182600	2024-06-28 18:04:03.516870	340c7758ecd5efcd6110885d46e8433b63074f2df303ba61fb...
SHOW TABLES FROM `lotesautos`	NULL	8	8	100.0000	0	0.0000	2024-06-28 18:00:55.433609	2024-06-28 18:01:05.263920	2f9d6b58f3183cf9ef22d9615868b256ea5a16c6a238fd8f95...
SELECT ? FROM `hotel` . `detail_fasilitas` LIMIT ?	NULL	6	6	100.0000	0	0.0000	2024-06-28 18:03:20.839572	2024-06-28 18:03:29.037736	b0bfd0c31257dd9442dc57ae3594bf1e09c4d8b05fc5cbc3f4...
SELECT ? FROM `hotel` . `detail_reservasi` LIMIT ?	NULL	6	6	100.0000	0	0.0000	2024-06-28 18:03:24.794966	2024-06-28 18:03:32.725639	574bf87244fd47e4653a5fe5b24675db3a0068f98c03e6d29d...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!