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.0091 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	1211	1211	100.0000	0	0.0000	2024-06-26 03:46:01.062983	2024-06-26 03:48:33.932520	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLES FROM `New_db`	NULL	74	74	100.0000	0	0.0000	2024-06-26 03:46:01.955334	2024-06-26 03:47:35.707350	b457ff5e49f95d1fc4f448413bd3b8ca6c4a3de3058804b2cd...
SHOW TABLES FROM `Website_db`	NULL	27	27	100.0000	0	0.0000	2024-06-26 03:46:01.154622	2024-06-26 03:46:04.652053	f50e21451a4855c82ab788e99476516b17aef0fa70ff05dba5...
SHOW TABLES FROM `Gg`	NULL	26	26	100.0000	0	0.0000	2024-06-26 03:46:01.198335	2024-06-26 03:47:22.614922	a18fec1f918ef95c949a41d257e31a8c10384ff744c3a43c3a...
SHOW TABLES FROM `training_website`	NULL	5	5	100.0000	0	0.0000	2024-06-26 03:46:04.140715	2024-06-26 03:46:10.969547	61fd7d2ccb0ee3cbfff1248fe340c0109fb4ca37fa9c4e5812...
SHOW TABLES FROM `ispit`	NULL	4	4	100.0000	0	0.0000	2024-06-26 03:46:45.119792	2024-06-26 03:47:27.663323	8fb978da815a666bff9116e3790785374ec953f906ac675043...
SHOW TABLES FROM `TEST`	NULL	4	4	100.0000	0	0.0000	2024-06-26 03:46:24.417326	2024-06-26 03:46:26.325923	388f381a4dfd7741b4c61765af4bfa34c7228a4a43fed7f9d6...
SHOW TABLES FROM `ispiti`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:47:05.520820	2024-06-26 03:47:05.554753	b703e6827d78c90182d395ff1cc3f5b52352d8217347dec558...
SHOW TABLES FROM `minggu 12`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:46:03.926741	2024-06-26 03:46:04.009579	ee4228aebc6191bbb7d12eec34b5efd35ab673f73bbe2b0945...
SHOW TABLES FROM `gardeen`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:46:04.129551	2024-06-26 03:46:04.220625	7c4892fc70e00edca469b9065d67f0ad736b2e3d381b5f7dfb...
SHOW TABLE STATUS FROM `Movies` WHERE `Name` LIKE ...	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:46:05.020275	2024-06-26 03:47:10.284137	d117c9b7d5ab6e6cc9555d67e02f844db0127a28114b5601bc...
SHOW TABLES FROM `music_site`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:47:44.645236	2024-06-26 03:47:44.702585	3826e38f5941c855aeffc2dfaa709b38c9cff7da80445a0403...
SHOW TABLES FROM `league`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:48:04.072978	2024-06-26 03:48:05.298329	f70d9f041652c2f39437ed9283894bb2b39eaf4dc0ba6d3262...
SHOW TABLES FROM `35230080_Gisella`	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:46:25.405351	2024-06-26 03:47:58.033444	f7c19f255504274bb64efb8fb97ba6aded6da4f2b60e3ef0fa...
SHOW FULL FIELDS FROM `35230080_Gisella` . `custom...	NULL	2	2	100.0000	0	0.0000	2024-06-26 03:46:25.406523	2024-06-26 03:46:25.406929	11f21bbf4c37d2e67b13fb1bbef562bcba2675f67af2ca2e86...
SELECT ? FROM `mysql` . `lost_book` LIMIT ?	mysql	2	2	100.0000	0	0.0000	2024-06-26 03:48:22.900132	2024-06-26 03:48:22.955579	89fd822ae0d084976a9d9524b37474d8310e16c4070bb1a3e7...
SHOW TABLES FROM `student_database`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:01.110817	2024-06-26 03:46:01.110817	43efe388b035ddfc30602ca1eeeeaba38f72f0f53732fdaa76...
SHOW TABLE STATUS FROM `LoginSystem` WHERE `Name` ...	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:01.527388	2024-06-26 03:46:01.527388	adbeb3feefc291e89722b02680b48336f9b1e8a44b1f8d2b00...
SELECT ? FROM `LoginSystem` . `usertable` LIMIT ?	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:01.548619	2024-06-26 03:46:01.548619	e0c280ccca673746482d0c8c192b455038f1b82cfeeca83bba...
SHOW TABLES FROM `atestat12B`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:45.506363	2024-06-26 03:46:45.506363	123600054e8b6f7f8bc187d40b9f1dd86c5361b05d5f58dedd...
SHOW TABLES FROM `tea_shop`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:01.837886	2024-06-26 03:46:01.837886	688d17129d5e6ce57b0fa8320ece462241d04d41036ba4945b...
SHOW TABLES FROM `TW23`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:54.691270	2024-06-26 03:46:54.691270	156d18730ea57256415f19d15d1c848db80a02165ab34d8d6d...
SHOW TABLES FROM `wordpressdb`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:46:58.301949	2024-06-26 03:46:58.301949	c44d4d226f7cb989592a3174440792b893159aa3966e675b47...
SHOW TABLES FROM `web_tk22b`	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:47:06.463758	2024-06-26 03:47:06.463758	5c602fee413a6f393aa9e5f09247551a394d9b044a21607a2b...
SHOW TABLE STATUS FROM `CarRental` WHERE `Name` LI...	NULL	1	1	100.0000	0	0.0000	2024-06-26 03:47:07.321524	2024-06-26 03:47:07.321524	383c357a0272c206b141ecba7bf4cc0bb184d465b0ca0d5451...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!