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	4357	4357	100.0000	0	0.0000	2024-09-26 06:01:04.374335	2024-09-26 06:11:24.498426	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `products` WHERE `Name` LIK...	NULL	102	102	100.0000	0	0.0000	2024-09-26 06:01:05.137615	2024-09-26 06:02:06.202516	26e35a75d9b59d4b604eb04a92dfd7d750acca99c62723f49e...
SHOW TABLE STATUS FROM `ecommerceweb` WHERE `Name`...	NULL	46	46	100.0000	0	0.0000	2024-09-26 06:02:35.215610	2024-09-26 06:06:14.167629	a62c6481cc6ad3dd74cce94aa612e02370250dd159fa3e0178...
SHOW TABLE STATUS FROM `product.sql` WHERE `Name` ...	NULL	16	16	100.0000	0	0.0000	2024-09-26 06:01:04.438234	2024-09-26 06:01:05.115224	3465111cca8471b02c255f038044803e41c36e3f04205da9d1...
SHOW TABLES FROM `products`	NULL	15	15	100.0000	0	0.0000	2024-09-26 06:01:07.273914	2024-09-26 06:01:59.183698	af0ba305b188fad68e23ee7b12cc6b46dd8b9b5d9fa81cd702...
SHOW TABLE STATUS FROM `INTERTEC` WHERE `Name` LIK...	NULL	15	15	100.0000	0	0.0000	2024-09-26 06:02:07.417692	2024-09-26 06:02:38.097755	1ccfd5abc7c38d5f42cf8935dec6e17c90ebb8e6ec8f690801...
SELECT ? FROM `INTERTEC` . `ADMINISTRADOR` LIMIT ?	NULL	15	15	100.0000	0	0.0000	2024-09-26 06:02:07.436825	2024-09-26 06:02:38.116564	b4604abaeb27d5eb709b63f2f254352cb65ee4f0a5344eda4a...
SELECT ? FROM `products` . `customers` LIMIT ?	NULL	14	14	100.0000	0	0.0000	2024-09-26 06:01:05.774871	2024-09-26 06:02:05.013686	782868fffdc75cd1e1453ea72cf82d456d5c5f51c36d542de7...
SELECT ? FROM `products` . `employees` LIMIT ?	NULL	14	14	100.0000	0	0.0000	2024-09-26 06:01:06.104403	2024-09-26 06:02:04.068015	cb62240659d5f16ae1c2ba4f0f53461d4459e5317002054f41...
SELECT ? FROM `products` . `suppliers` LIMIT ?	NULL	14	14	100.0000	0	0.0000	2024-09-26 06:01:06.527751	2024-09-26 06:02:00.376866	791a662bb9e2a3da9a5407d6f7c1a994e8c400bbb016359e73...
SELECT ? FROM `products` . `products` LIMIT ?	NULL	13	13	100.0000	0	0.0000	2024-09-26 06:01:05.185458	2024-09-26 06:01:48.930085	7f25d40dd4e6687df7a821888f058acc0044dab34b3f0c59ff...
SELECT ? FROM `products` . `shippers` LIMIT ?	NULL	13	13	100.0000	0	0.0000	2024-09-26 06:01:05.351516	2024-09-26 06:01:52.883380	34ab7b80a1bac841add1a6333af6a2f76d544fe3ddb68655e7...
SELECT ? FROM `products` . `orders` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-09-26 06:01:05.724984	2024-09-26 06:01:43.211415	c801e3d75b5e8d457c8a0ecd7c04e011410191c6b9a5c2062f...
SELECT ? FROM `ecommerceweb` . `tbl_color` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-09-26 06:02:35.234869	2024-09-26 06:05:57.987400	21589f79c2e351349a64bd49c2d78569ba421606cec94e48bf...
SELECT ? FROM `ecommerceweb` . `tbl_order` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-09-26 06:02:42.974207	2024-09-26 06:06:06.172686	7d882eb7e7bd4f9daad6b99bfe1d9d1310ae0ecbe0a2415b65...
SELECT ? FROM `ecommerceweb` . `tbl_photo` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-09-26 06:02:47.614159	2024-09-26 06:06:10.400612	2c62d7ee83b6c634bee7da8980a2762ec4b5fcdfa0bae9c0bb...
SHOW TABLES FROM `ecommerceweb`	NULL	12	12	100.0000	0	0.0000	2024-09-26 06:02:13.911375	2024-09-26 06:02:29.994702	80de1e8cc2146dab10d55337c979492aaca167f1f23b9a8ae2...
CREATE TABLE `users` ( `id` INTEGER AUTO_INCREMENT...	fy1	12	11	91.6667	0	0.0000	2024-09-26 06:08:29.448081	2024-09-26 06:11:19.236965	c255cba53eb9271fb0be3dcdd153d3d24a438e2318c1b64197...
SELECT ? FROM `ecommerceweb` . `tbl_video` LIMIT ?	NULL	10	10	100.0000	0	0.0000	2024-09-26 06:02:55.246208	2024-09-26 06:06:14.186541	5fd588938ff0613168539c69153b7ef9c3cba5b37169e1e1cc...
SELECT ? FROM `products` . `categories` LIMIT ?	NULL	7	7	100.0000	0	0.0000	2024-09-26 06:01:08.594967	2024-09-26 06:02:06.226170	d6ba4cdb0a2c6ef72efb840e65d7cad8bc684cd470120413fc...
SHOW TABLES FROM `Tickets`	NULL	4	4	100.0000	0	0.0000	2024-09-26 06:03:43.185460	2024-09-26 06:10:39.950517	347615dc80d8a50f829bacac558f18480bf5b5e6781ad24123...
SELECT ? FROM `product.sql` . `order_details` LIMI...	NULL	4	4	100.0000	0	0.0000	2024-09-26 06:01:04.566012	2024-09-26 06:01:04.764901	7a60a1c36b601efb56676720c1cfb53e16439158b3b6623bb6...
SHOW TABLE STATUS FROM `Tickets` WHERE `Name` LIKE...	NULL	4	4	100.0000	0	0.0000	2024-09-26 06:03:43.286751	2024-09-26 06:08:47.135234	ca17c9ffa6204d6738680bb9c9e3e368881b52e68b75f7c9f1...
SHOW TABLES FROM `product.sql`	NULL	4	4	100.0000	0	0.0000	2024-09-26 06:01:07.014891	2024-09-26 06:01:43.359165	aaa7a5ba34712107decb2a2a096685db9b47260fe56c102217...
SHOW FIELDS FROM `muhammad waqas` . `123`	muhammad waqas	4	4	100.0000	0	0.0000	2024-09-26 06:03:13.570005	2024-09-26 06:04:54.127787	141d1b98fe071e21be288438936e756bcaed12a2fd108ad668...

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.