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.0051 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	903	903	100.0000	0	0.0000	2024-06-21 21:46:01.074228	2024-06-21 21:55:43.449192	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW FIELDS FROM `rajcomputers` . `student`	mysql	16	16	100.0000	0	0.0000	2024-06-21 21:46:01.973352	2024-06-21 21:46:04.433643	c8df15262a016640d5644e375e4fa414c7579b457ace020256...
SHOW TABLES FROM `rajcomputers`	mysql	16	16	100.0000	0	0.0000	2024-06-21 21:46:02.603310	2024-06-21 21:46:42.072762	c9ce219f6cb15e3819f15b2cbbeb55ac4a1030c7e08cf520a4...
SHOW TABLES FROM `rajcomputers`	NULL	14	14	100.0000	0	0.0000	2024-06-21 21:46:03.048348	2024-06-21 21:46:50.642324	c9ce219f6cb15e3819f15b2cbbeb55ac4a1030c7e08cf520a4...
SHOW TABLES FROM `Market`	mysql	14	14	100.0000	0	0.0000	2024-06-21 21:46:11.701405	2024-06-21 21:47:42.041113	6bf13793ee7299130c47bc31b03c1283148bccdc8515fa7c54...
SHOW TABLES FROM `ptabc`	mysql	12	12	100.0000	0	0.0000	2024-06-21 21:46:02.942021	2024-06-21 21:47:20.951810	1ea658bb57ac5eacbb59928989c6552c720f9d06fac96d59d8...
SHOW FIELDS FROM `Market` . `Utilisateur`	mysql	8	8	100.0000	0	0.0000	2024-06-21 21:46:03.088187	2024-06-21 21:46:03.637581	d25ecfeba2968168380a52ea36b1b03bbd56df3438c156dc67...
SHOW FIELDS FROM `Market` . `Adresse`	mysql	8	8	100.0000	0	0.0000	2024-06-21 21:46:07.652726	2024-06-21 21:46:25.816045	30655e803bbeee9e69ddd9bb09f48f7d604a7b047e06591de2...
SHOW FIELDS FROM `Market` . `items`	mysql	8	8	100.0000	0	0.0000	2024-06-21 21:46:53.906464	2024-06-21 21:47:07.546648	15afe2d1a86288921e8240c606403dfe90bd7c8e53bc6f8a50...
SHOW TABLES FROM `original`	mysql	7	7	100.0000	0	0.0000	2024-06-21 21:47:49.645215	2024-06-21 21:47:55.508533	699f93c87d7fd669924c5e7c7f526001b4cd59030db5fbf2bb...
SHOW TABLES FROM `shop`	mysql	6	6	100.0000	0	0.0000	2024-06-21 21:46:56.669013	2024-06-21 21:47:44.555527	a3ec4208f5cd51d50dd0652d45cc60837c2577ad666be1bd97...
SHOW TABLES FROM `Hope`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:46:01.222366	2024-06-21 21:46:03.967029	cd406b985ece97f662d8afccfcd9f35f92b439094c7e43673b...
SHOW FIELDS FROM `Lab5` . `Registration`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:46:01.637987	2024-06-21 21:46:01.861199	7aed066f1634084a0b65ddc77a79a2f7acf1135f02bb0b3258...
SHOW FIELDS FROM `ptabc` . `karyawan`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:46:02.235237	2024-06-21 21:46:02.649739	65c594f8fc4856e297edf48dfc2325e49020125e93a4b87728...
SHOW TABLES FROM `FullCalendar`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:46:03.339574	2024-06-21 21:46:03.521409	1f410a634dc623b0b052e47687b4c4b921c2ebcc0473ca62c3...
SHOW TABLE STATUS FROM `Market` WHERE `Name` LIKE ...	NULL	4	4	100.0000	0	0.0000	2024-06-21 21:46:18.492452	2024-06-21 21:47:06.188282	57c1ed503a7d0647c58943fb9d47800b19869ddcfec725012d...
SHOW FIELDS FROM `shop` . `goods`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:46:49.577579	2024-06-21 21:46:59.905262	7ab3f02c6ae5b4b63b75a2e47aae4a69fed5e55cc12601f8e5...
SHOW TABLES FROM `college`	mysql	4	4	100.0000	0	0.0000	2024-06-21 21:47:08.650570	2024-06-21 21:47:11.499955	6f6bc5dcd38b52c615a090e83b80539e1965a70c0fda179312...
SHOW TABLES FROM `Hope`	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:01.382356	2024-06-21 21:46:02.762854	cd406b985ece97f662d8afccfcd9f35f92b439094c7e43673b...
SHOW FIELDS FROM `admin_galaxy` . `booking_details...	mysql	2	2	100.0000	0	0.0000	2024-06-21 21:46:01.516932	2024-06-21 21:46:01.562251	b961b45f3cf685ca5dc3f412c34a8cfca090f0a6f1950a6a9e...
SHOW INDEXES FROM `DJOYAMADO` . `ALUNO`	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:01.670565	2024-06-21 21:46:01.856997	457228507aaf31302d3cfa235a4931ba34cac207524dafd86c...
SHOW TABLE STATUS FROM `DJOYAMADO` WHERE `Name` LI...	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:01.712719	2024-06-21 21:46:01.900515	eb7c88150920e39c6691d893328c03d4b6da022c0690bb2f43...
SELECT ? FROM `DJOYAMADO` . `ALUNO` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:01.732875	2024-06-21 21:46:01.926300	d498d92ce04b3c0d76e6f8b67bb947e2f66d3dc15d1589b532...
SHOW TABLES FROM `Market`	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:10.873030	2024-06-21 21:46:19.674395	6bf13793ee7299130c47bc31b03c1283148bccdc8515fa7c54...
SELECT ? FROM `Market` . `Adresse` LIMIT ?	NULL	2	2	100.0000	0	0.0000	2024-06-21 21:46:18.517565	2024-06-21 21:46:19.140277	fcc8b4553cba34e0bded0a1516461aa8d16078f9f77c26c97b...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!