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.

Your SQL query has been executed successfully.

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	331	331	100.0000	0	0.0000	2024-09-27 18:16:01.254703	2024-09-27 18:16:36.472142	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `resort` WHERE `Name` LIKE ...	NULL	11	11	100.0000	0	0.0000	2024-09-27 18:16:02.792087	2024-09-27 18:16:07.644967	a208cd09dd2251e29ad1b71f2d9d7483e47d1a60b89b15274c...
SHOW TABLE STATUS FROM `axel` WHERE `Name` LIKE ?	NULL	8	8	100.0000	0	0.0000	2024-09-27 18:16:01.707918	2024-09-27 18:16:14.243015	55ff6a896331d82731f70bd48197bc47403caf5f0fc9c37214...
SHOW TABLE STATUS FROM `m.com` WHERE `Name` LIKE ?	NULL	7	7	100.0000	0	0.0000	2024-09-27 18:16:08.012075	2024-09-27 18:16:19.498910	dd9a35d3034a5b1585068c41d0d7b5e89a436bf766c571bb5b...
SHOW TABLE STATUS FROM `agms.sql` WHERE `Name` LIK...	NULL	7	7	100.0000	0	0.0000	2024-09-27 18:16:03.249333	2024-09-27 18:16:04.386214	1f56467542bbdff3ef42234336f88095e356347640c75ea7bf...
SHOW TABLES FROM `resort.sql`	NULL	5	5	100.0000	0	0.0000	2024-09-27 18:16:07.741934	2024-09-27 18:16:08.357408	2f6bb55b948f0cd371c15d2eaa0cbf36f928eb6f675157ab44...
SELECT ? FROM `m.com` . `Plantas` LIMIT ?	NULL	5	5	100.0000	0	0.0000	2024-09-27 18:16:08.067791	2024-09-27 18:16:19.526188	b923cf8f3bf085001c65399090febfb39bc05318efc8af6fb3...
SHOW TABLES FROM `PHPMYADMIN`	NULL	5	5	100.0000	0	0.0000	2024-09-27 18:16:04.653346	2024-09-27 18:16:06.401886	b9793dfaf3621628cd8923e5be27dba61c2887388e3e1c4843...
SELECT ? FROM `agms.sql` . `tblartist` LIMIT ?	NULL	4	4	100.0000	0	0.0000	2024-09-27 18:16:03.617946	2024-09-27 18:16:04.383739	c19f54a230f97ea85562d5eb83428c989bb7b3dbf301e6ef22...
SELECT ? FROM `axel` . `alumno` LIMIT ?	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:01.747049	2024-09-27 18:16:14.264522	dce2202ae3085c0e7f74fc3f662bb1bc9aef7b242d4d301dff...
SHOW TABLES FROM `axel`	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:01.870547	2024-09-27 18:16:14.209616	4bd57f1182e04aa13a749dae36ac3d67b9a8f35ca7ea6f070b...
SELECT ? FROM `axel` . `cursos` LIMIT ?	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:01.950194	2024-09-27 18:16:10.825688	b91d5221eb6148bd26d84def7315321d43fa49c84d030610a6...
SELECT ? FROM `resort` . `login` LIMIT ?	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:02.820402	2024-09-27 18:16:06.922119	d743d725a2fd8b569278eac9187ce6cbf0457bf8b3234ff512...
SHOW TABLES FROM `agms.sql`	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:04.427669	2024-09-27 18:16:06.368243	3fd00227e0c62d30c4593506785017f9a70588dce5e56d0b0f...
SHOW TABLES FROM `travel_ticket_register`	NULL	3	3	100.0000	0	0.0000	2024-09-27 18:16:07.077352	2024-09-27 18:16:24.257702	5022b5e8114bbdafe59ad8aa4ccd5c6cc1e4d02074cffd7419...
SHOW TABLES FROM `meu_teste`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:07.301539	2024-09-27 18:16:07.366120	2c348560fc5fcc696577d8239210eafcca2419903e48619fe7...
SHOW TABLES FROM `slbzhnnv`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:07.852333	2024-09-27 18:16:07.914741	050cc4cf27e490cbe9edcf328b5719bedfe0994c1ad69e54ad...
SHOW FIELDS FROM `m.com` . `Plantas`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:08.820631	2024-09-27 18:16:18.012050	19ad80e999a4cacdf753f708857cb6ec15ff8088b2d2aaafcc...
SHOW TABLE STATUS FROM `m.com`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:08.820808	2024-09-27 18:16:18.012346	daf5409a1425a139d2495105de6d0dff611bf1755e84cf2f90...
SHOW TABLE STATUS FROM `axel`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:01.786419	2024-09-27 18:16:02.073773	525a82c96fa3b4ca250f7be148784a34b3c97d0eee8b9b5724...
SHOW TABLES FROM `c_management`	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:02.509944	2024-09-27 18:16:02.700990	ab9a1e66e55e9d1f63af53b4582ff9b6d82f297ef5255bbe46...
SELECT ? FROM `resort` . `rating` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:03.128638	2024-09-27 18:16:04.860071	a65a15cc73d64b2a9e19c11caad28fc072c3bfe52f5bc364fb...
SELECT ? FROM `resort` . `manager` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:06.996365	2024-09-27 18:16:07.725430	09285bc1032eeaac3d9193629525680a77068c6e77fac71d8a...
SELECT ? FROM `resort` . `message` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-09-27 18:16:07.285468	2024-09-27 18:16:07.647858	e35d914f03a8d96d70f72668c66eaa4606809fe7577500f6f5...
SHOW TABLES FROM `tp1`	NULL	1	1	100.0000	0	0.0000	2024-09-27 18:16:01.402617	2024-09-27 18:16:01.402617	6c63a9f2289b4e82bd117f7bd07b30649ee91ce5ebb0a772f3...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Currently running Git revision RELEASE_5_2_1-4907-g5b04607256 from the master branch.