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.

Showing rows 0 - ...

(Query took 0.2324 seconds.)

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	6162	6162	100.0000	0	0.0000	2024-07-03 08:00:47.095033	2024-07-03 08:13:38.563470	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `DepartmentalStore` WHERE `...	NULL	48	48	100.0000	0	0.0000	2024-07-03 08:00:47.477042	2024-07-03 08:09:31.631569	5fa0abd93db5c5148b7d71ce0ef324a9ff117ea7cd3ad4b82b...
SELECT ? FROM `tabel_posyandu` . `tabel_kader_posy...	NULL	20	20	100.0000	0	0.0000	2024-07-03 08:01:18.646849	2024-07-03 08:02:06.155106	1cde27915aee50fb7bab62b0f3024653a04d4bd9de1f6495c2...
SHOW TABLE STATUS FROM `аа` WHERE `Name` LIKE ?	NULL	19	19	100.0000	0	0.0000	2024-07-03 08:05:34.903887	2024-07-03 08:08:53.881448	84dc9b696354ce99c5ceb8106b27a7ea1c3b947c0249154805...
SELECT ? FROM `аа` . `Поставщик` LIMIT ?	NULL	17	17	100.0000	0	0.0000	2024-07-03 08:05:34.945214	2024-07-03 08:08:53.910730	bb420d9d75049dd210436ba1cc7096f8c81e419d6e33a21be0...
SELECT ? FROM `tabel_posyandu2` . `tabel_pengguna_...	NULL	13	13	100.0000	0	0.0000	2024-07-03 08:04:44.735737	2024-07-03 08:06:36.090504	3cb029cbed0040af7ded1fcb8e3f78b58148611908c5f14bcf...
SHOW TABLES FROM `kaau`	mysql	12	12	100.0000	0	0.0000	2024-07-03 08:00:50.041320	2024-07-03 08:08:48.856686	b0984fe8ed1e065a609d0bf808278a0fbb4e863e454a7f79e6...
SHOW FULL FIELDS FROM `DepartmentalStore` . `Emplo...	NULL	12	12	100.0000	0	0.0000	2024-07-03 08:00:58.828465	2024-07-03 08:01:43.048822	4fd752cb144f6eef8a668de0a0e80779d40f790f97612eb090...
SHOW TABLES FROM `DepartmentalStore`	NULL	11	11	100.0000	0	0.0000	2024-07-03 08:00:47.183604	2024-07-03 08:03:51.438456	c075162371482327fa44fb37f5c95dc5a886ad18c03f416db5...
SHOW FULL FIELDS FROM `DepartmentalStore` . `Produ...	NULL	10	10	100.0000	0	0.0000	2024-07-03 08:03:30.878277	2024-07-03 08:03:34.829946	b5ea1e524bb08630afacc39c2cc8678a4ddcfae7481c34ceef...
SHOW TABLE STATUS FROM `sakila` WHERE `Name` LIKE ...	NULL	9	9	100.0000	0	0.0000	2024-07-03 08:03:40.876060	2024-07-03 08:12:44.841014	4f604bda5381e43a55ae4d5b97d5b9b7eef3814c27f46ecb93...
SHOW TABLES FROM `database_film`	NULL	9	9	100.0000	0	0.0000	2024-07-03 08:04:02.590021	2024-07-03 08:04:17.314942	eccf1ccbd57415796b4a9a593b17df10e031fb31e51322e98e...
SELECT ? FROM `ram` . `item` LIMIT ?	NULL	20	9	45.0000	0	0.0000	2024-07-03 08:01:52.320845	2024-07-03 08:06:35.959271	576ab133321edfd7c900649b4a7d6448e2de8085fa9747480a...
SHOW TABLE STATUS FROM `taobao` WHERE `Name` LIKE ...	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:05:38.012801	2024-07-03 08:09:07.719655	8dc45286aefaf013af54f74b054bbe6b11359fafc17e88a128...
SHOW TABLES FROM `Tabel_balita`	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:05:57.834936	2024-07-03 08:06:07.683700	cf2b1343dd4270aafbcaade3eeae1932e0dd511f6a2e622af0...
SHOW FULL FIELDS FROM `аа` . `Поставщик`	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:07:15.291165	2024-07-03 08:08:08.260947	acb4f694b749ccb08e9f8638a25258036d76d2d5a663ad003f...
SHOW FULL FIELDS FROM `DepartmentalStore` . `Pays`	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:03:25.825660	2024-07-03 08:03:29.824060	c562fded03d6d371b15c641df4a7e8d5906c635e837ab13d65...
SHOW FULL FIELDS FROM `DepartmentalStore` . `Sales...	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:03:42.880819	2024-07-03 08:03:46.982446	d228ab80488ef13142fb15853beaf76f8279d85b57d24694dc...
SELECT ? FROM `DepartmentalStore` . `Employees` LI...	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:00:58.900351	2024-07-03 08:03:01.648836	ed543cd03da41cc837b75c83560f6da01906fb05b97bba1b2f...
SHOW TABLES FROM `DepartmentalStore`	mysql	8	8	100.0000	0	0.0000	2024-07-03 08:01:19.601047	2024-07-03 08:09:32.845464	c075162371482327fa44fb37f5c95dc5a886ad18c03f416db5...
SHOW FULL FIELDS FROM `DepartmentalStore` . `Branc...	NULL	8	8	100.0000	0	0.0000	2024-07-03 08:01:27.361434	2024-07-03 08:01:34.958143	9f71dc57a7c8c6edb79e4df43aa8e87ab2de0fe87db43c62eb...
SHOW TABLES FROM `momo`	mysql	8	8	100.0000	0	0.0000	2024-07-03 08:04:28.646262	2024-07-03 08:04:41.922984	c3db8b8f946c82adba2c0fe21335f210181b8fa279445ba5de...
SELECT ? FROM `DepartmentalStore` . `Products` LIM...	NULL	7	7	100.0000	0	0.0000	2024-07-03 08:03:30.957275	2024-07-03 08:03:43.602537	0caa74fac643c482861ed584c0857fcb039729743570d1dc2d...
SHOW TABLES FROM `аа`	NULL	7	7	100.0000	0	0.0000	2024-07-03 08:03:42.438686	2024-07-03 08:06:41.925028	5862b0742f1c28a7d7dc8df3d4cd7abc8b9358011e31048301...
SELECT ? FROM `test` . `Registration` LIMIT ?	NULL	7	7	100.0000	0	0.0000	2024-07-03 08:01:29.459829	2024-07-03 08:03:26.235748	d3d830fd96d01b5e2971380bb241d4085639c8de362fefe5d1...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!