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.0050 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	1408	1408	100.0000	0	0.0000	2024-06-28 19:31:01.870668	2024-06-28 19:43:44.479547	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `projet` WHERE `Name` LIKE ...	NULL	17	17	100.0000	0	0.0000	2024-06-28 19:31:03.397110	2024-06-28 19:43:43.420173	4ff17bf60a4735157ca24dfdbf564c2bb3a68630d6bce61c8d...
SHOW TABLE STATUS FROM `bd_colegio` WHERE `Name` L...	NULL	14	14	100.0000	0	0.0000	2024-06-28 19:31:05.010800	2024-06-28 19:42:28.860951	373fbfa51c270dcfdf5b75697d2ce7e1a8161af9f660687c63...
SHOW TABLE STATUS FROM `bd_registro` WHERE `Name` ...	NULL	8	8	100.0000	0	0.0000	2024-06-28 19:31:44.061741	2024-06-28 19:42:31.546631	0622febf2c0095460affa3bf3f2259e7d22baab8fa49d12425...
SHOW TABLE STATUS FROM `gallery_db` WHERE `Name` L...	NULL	8	8	100.0000	0	0.0000	2024-06-28 19:33:41.801302	2024-06-28 19:38:43.534805	87e7be062fdbfb42c2f7f9047d20d2c935b36c3cee3cdc9717...
SELECT ? FROM `gallery_db` . `images` LIMIT ?	NULL	8	8	100.0000	0	0.0000	2024-06-28 19:33:41.822135	2024-06-28 19:38:43.560841	c14e66cd6c094dd8482654de10622322b07db37fd4f2b5f2d7...
SHOW TABLES FROM `Products`	NULL	7	7	100.0000	0	0.0000	2024-06-28 19:32:01.432479	2024-06-28 19:40:08.987978	68d2709908544b0667f2b8b3f12894a1f5b754bac46002b7d8...
SHOW TABLES FROM `rabea/pyp`	NULL	6	6	100.0000	0	0.0000	2024-06-28 19:31:23.008404	2024-06-28 19:41:58.113875	def50c16b74381757ba9158cb1ba767921d09fe0cf632df981...
SHOW TABLES FROM `Mec_academy`	NULL	6	6	100.0000	0	0.0000	2024-06-28 19:31:02.044745	2024-06-28 19:43:17.182196	c8d9fa40968aa270e20131d0908ca5c41941059b9be958bcf4...
SHOW TABLE STATUS FROM `Products` WHERE `Name` LIK...	NULL	6	6	100.0000	0	0.0000	2024-06-28 19:35:23.831036	2024-06-28 19:43:31.327813	de459ddb31a17bbc353bed4098f0bd83487b6b3a31175a5742...
SELECT ? FROM `bd_registro` . `responsable` LIMIT ...	NULL	6	6	100.0000	0	0.0000	2024-06-28 19:33:41.073068	2024-06-28 19:42:31.565141	2b78b26e3cc6b44b2111ab0fdb9b5a3813e0658c531163acd9...
SHOW TABLE STATUS FROM `roshan_demo` WHERE `Name` ...	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:34:55.596928	2024-06-28 19:39:55.112700	7634ca19caa4421d8e5958ac6c5fae882ed905d1f42b266b64...
SHOW TABLES FROM `huy_php`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:35:07.513851	2024-06-28 19:41:51.209034	3930b388797cb0309e9630270dc642e8e7cf20c6f266b0a70e...
SELECT ? FROM `Products` . `categories` LIMIT ?	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:35:23.849846	2024-06-28 19:43:31.350193	ff35e59b854628862cd1959c275258f506fec3543c706d7ab6...
SHOW TABLES FROM `tourism_in_Wales`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:31:45.116775	2024-06-28 19:40:45.933913	c922ae4d9005fae872aa0f7c9ef0bedd5d11191da193864c85...
SHOW TABLES FROM `cjd`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:35:27.683461	2024-06-28 19:41:47.658840	87987cc9a29fdc53a7dab437468581fa7b0f28b9b3c282c081...
SHOW TABLE STATUS FROM `BANCO_TESTE` WHERE `Name` ...	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:31:52.768358	2024-06-28 19:40:06.061571	e6c8ba36634a7362f7b29702398f7775a400bce84e69173c82...
SHOW TABLES FROM `gym`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:36:55.659857	2024-06-28 19:42:54.746896	60da0416e01995e51ca5857ae9f3cab48c61ae4edbae016754...
SHOW TABLES FROM `BIBLIOTECA`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:31:03.293994	2024-06-28 19:42:27.410795	e1da55c43c7bf5d6b0df6d214c4ad3978633fe1f978afc1e97...
SHOW TABLES FROM `bd_registro`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:37:11.258745	2024-06-28 19:43:31.621966	f3f3fddb41fc1b607f9fa3d96a1c5fa0a5f30784c241f197ec...
SHOW TABLES FROM `projecto_m1`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:31:03.573433	2024-06-28 19:42:05.883160	b5c59d5eb59517dbab8cfb28d261c0edad3bbf01818283077d...
SHOW TABLES FROM `abc_english`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:31:03.973091	2024-06-28 19:38:49.162431	c56766c6a44d9956d9e4c407d379fef7beed77d86811d5585e...
SHOW TABLE STATUS FROM `"Институт"` WHERE `Name` L...	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:32:55.604472	2024-06-28 19:41:02.730659	1644ff8ab0b5abef11f9240ff1bc0edd8b6c589bd35526d09d...
SHOW TABLES FROM `script1`	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:33:23.397647	2024-06-28 19:42:03.632686	d6bc7408fcae4d1263b0595e10c473e1ad1751b2a867c7fab0...
SHOW TABLE STATUS FROM `video_db` WHERE `Name` LIK...	NULL	5	5	100.0000	0	0.0000	2024-06-28 19:33:31.246382	2024-06-28 19:42:45.106092	ea21e7e1daf2a70de43781d086edd05d8617ad48e40c4ed301...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!