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.0048 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	1388	1388	100.0000	0	0.0000	2024-06-24 13:15:47.427343	2024-06-24 13:26:25.155575	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW FIELDS FROM `teste_teste` . `test`	teste_teste	2	2	100.0000	0	0.0000	2024-06-24 13:22:19.401077	2024-06-24 13:22:42.061639	652da6370700ed39fbe5c6f69ebaaf6e08d0a42ee2a1ef5d91...
SHOW FULL FIELDS FROM `Husan Preet Singh` . `Produ...	NULL	2	2	100.0000	0	0.0000	2024-06-24 13:25:09.266677	2024-06-24 13:25:09.268242	7c81c298536a1c1cfa19858ee291a635caf30be6300cf09379...
SHOW TABLES FROM `ProjectUas`	NULL	2	2	100.0000	0	0.0000	2024-06-24 13:19:03.638868	2024-06-24 13:24:54.208474	569cba8bce9f9e9cd00715aae5802efdb322acf255e0b9c6a6...
SHOW TABLES FROM `school`	NULL	2	2	100.0000	0	0.0000	2024-06-24 13:20:58.268203	2024-06-24 13:22:53.930030	e44e0c29a51db84c08a8654d9b7944b13a87ba60ca3cfb405f...
SHOW TABLES FROM `codeanddesign`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:22:16.309428	2024-06-24 13:22:16.309428	2a2874845a0cbc371c06b229081d4034cd49c05ae0d957d3d5...
SHOW FULL FIELDS FROM `teste_teste` . `test`	teste_teste	1	1	100.0000	0	0.0000	2024-06-24 13:22:19.402711	2024-06-24 13:22:19.402711	2f5563788e68871045c155f42761fc82c3ab305fa05e1ac33a...
SHOW CREATE TABLE `teste_teste` . `test`	teste_teste	4	1	25.0000	0	0.0000	2024-06-24 13:22:19.403119	2024-06-24 13:26:04.423747	1e3f9a180c4506f178ded95c703f7134d68146249e752325ff...
SELECT ? FROM `teste_teste` . `test` LIMIT ?	teste_teste	16	1	6.2500	0	0.0000	2024-06-24 13:22:19.451965	2024-06-24 13:26:04.535700	7d087154b423b1c910be78f03c2ad7504d01685e9d99ff9231...
SHOW TABLES FROM `admin`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:22:23.776997	2024-06-24 13:22:23.776997	2ac76e4bff765d130e728a68b84a66ea7d6cea1b5a2b51be47...
SELECT ? FROM `teste_teste` . `test` LIMIT ?	NULL	3	1	33.3333	0	0.0000	2024-06-24 13:22:41.966263	2024-06-24 13:23:32.260010	7d087154b423b1c910be78f03c2ad7504d01685e9d99ff9231...
SHOW TABLES FROM `Quanlysanpham`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:22:59.513673	2024-06-24 13:22:59.513673	d7749383a1fddf415a32671a68c780110d2286b18c981eb65e...
SELECT * FROM `address` WHERE `fdistrict` = ? AND ...	sakila	1	1	100.0000	0	0.0000	2024-06-24 13:23:05.663106	2024-06-24 13:23:05.663106	37d5a40b1462840f9ee9c5b2ff268780b85b88dd4c80f96939...
SELECT * FROM `address` WHERE `district` = ? AND (...	sakila	1	1	100.0000	0	0.0000	2024-06-24 13:23:13.937624	2024-06-24 13:23:13.937624	4721f9a1fb088b987f9712639812d69ca7f024b5cc664d60c0...
SHOW TABLES FROM `formation`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:48.824395	2024-06-24 13:15:48.824395	13cf1935777f8e7940893fb6583b21be3ddc1558fbc70612a8...
SHOW TABLES FROM `moreshwar_tea_shop`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:49.711323	2024-06-24 13:15:49.711323	892f7a9e388219526d91f78d52fbb500edcba9284570d43789...
SHOW TABLES FROM `4B02`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:51.100296	2024-06-24 13:15:51.100296	1712333a3e212f5cac13161aa8ac6008266c11832bfa422d58...
SHOW TABLES FROM `Betka`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:51.372204	2024-06-24 13:15:51.372204	17dc59b2d666974db4e92ac9826a94ab870fb72162d4e9ce7a...
SHOW TABLES FROM `Clinica medica`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:51.781043	2024-06-24 13:15:51.781043	a9c6468c38af44a8709d341fc4c02a29d8fa570d7601da408a...
SHOW TABLES FROM `Rodny`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:52.174997	2024-06-24 13:15:52.174997	8cb90791e45cd5736b510897483504fd48f0a912c9c413bcd1...
SHOW TABLES FROM `class_api`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:52.515085	2024-06-24 13:15:52.515085	0b75986ebf8d07e28ed17559237b7a8575ef19e1b634bfd510...
SHOW TABLES FROM `ksc12`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:52.867747	2024-06-24 13:15:52.867747	1296aeaedf031ae4ebe4ccb31973cddd6cc60ac6bf947473e0...
SHOW TABLES FROM `Daniel`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:15:58.547202	2024-06-24 13:15:58.547202	d8d6c18fbcb1f7ae4b06992d55cca61a04226fd8552be057bd...
SHOW TABLES FROM `coisas`	NULL	1	1	100.0000	0	0.0000	2024-06-24 13:24:49.836032	2024-06-24 13:24:49.836032	92306eb2bbddf81bf49238ca78ba1eedc9d299b88aee50e5ee...
SHOW FIELDS FROM `ITProger` . `users`	ITProger	1	1	100.0000	0	0.0000	2024-06-24 13:24:50.257760	2024-06-24 13:24:50.257760	731f48bbc9b5f8847e70e45902eb8c1cadc5c242d325122d3e...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!