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.0089 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	2522	2522	100.0000	0	0.0000	2024-06-28 01:31:01.888977	2024-06-28 01:41:42.526109	f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99...
SHOW TABLE STATUS FROM `projet` WHERE `Name` LIKE ...	NULL	512	512	100.0000	0	0.0000	2024-06-28 01:31:47.602306	2024-06-28 01:41:41.650832	4ff17bf60a4735157ca24dfdbf564c2bb3a68630d6bce61c8d...
SHOW TABLE STATUS FROM `bd_registro` WHERE `Name` ...	NULL	96	96	100.0000	0	0.0000	2024-06-28 01:31:01.971354	2024-06-28 01:31:41.831094	0622febf2c0095460affa3bf3f2259e7d22baab8fa49d12425...
SHOW TABLES FROM `projet`	NULL	70	70	100.0000	0	0.0000	2024-06-28 01:36:39.673575	2024-06-28 01:41:41.618125	2926870c234ab421ef505985645baa7d6180fddbc4dd13e368...
SELECT ? FROM `bd_registro` . `solicitante` LIMIT ...	NULL	44	44	100.0000	0	0.0000	2024-06-28 01:31:01.990940	2024-06-28 01:31:33.009982	e69f06b334eb19b24bd7976909bbfc370eb3645fde943b88ab...
SELECT ? FROM `bd_registro` . `responsable` LIMIT ...	NULL	44	44	100.0000	0	0.0000	2024-06-28 01:31:02.069625	2024-06-28 01:31:24.969701	2b78b26e3cc6b44b2111ab0fdb9b5a3813e0658c531163acd9...
SELECT ? FROM `projet` . `client` LIMIT ?	NULL	36	36	100.0000	0	0.0000	2024-06-28 01:33:15.419640	2024-06-28 01:40:52.861764	6f6a87c29a78598e44d3a26943163b9a1c22bebb9a10e525cf...
SELECT ? FROM `projet` . `commande` LIMIT ?	NULL	34	34	100.0000	0	0.0000	2024-06-28 01:35:14.978431	2024-06-28 01:40:57.715186	9cf5769ae828cbce12cc946472c88a9f15c23955465fffd637...
SELECT ? FROM `projet` . `pointage` LIMIT ?	NULL	33	33	100.0000	0	0.0000	2024-06-28 01:34:47.045140	2024-06-28 01:41:35.079204	9aa6760a73e21e52211fe25cdbe475957b20acfdfa383ce200...
SELECT ? FROM `projet` . `commerce` LIMIT ?	NULL	33	33	100.0000	0	0.0000	2024-06-28 01:35:13.818119	2024-06-28 01:41:08.862549	a6187132c021dea19325f8f4253156684774b127a131e8e201...
SELECT ? FROM `projet` . `projet` LIMIT ?	NULL	32	32	100.0000	0	0.0000	2024-06-28 01:31:50.014607	2024-06-28 01:41:38.945660	4340d32c92746f590f92499b0f4e9346469be2c32049b815cf...
SELECT ? FROM `projet` . `produits` LIMIT ?	NULL	26	26	100.0000	0	0.0000	2024-06-28 01:34:46.208865	2024-06-28 01:41:41.670313	8c593186a92398467feea5f1212b2833b134d614811d905612...
SELECT ? FROM `projet` . `absenteisme` LIMIT ?	NULL	26	26	100.0000	0	0.0000	2024-06-28 01:35:31.391649	2024-06-28 01:40:43.676438	f6b3654c23f49a2ea7074f00fbcd20a0ef8ba347f7feb9c62f...
SELECT ? FROM `projet` . `departement` LIMIT ?	NULL	26	26	100.0000	0	0.0000	2024-06-28 01:35:35.953758	2024-06-28 01:41:20.880928	3ef787712572d6e90a85bbf569c34bfb152b1b512fce542f4b...
SELECT ? FROM `projet` . `facturation` LIMIT ?	NULL	26	26	100.0000	0	0.0000	2024-06-28 01:35:41.791741	2024-06-28 01:41:19.608274	a8dbead5b3713651e5a7f620de85b7c38065dd21a1fbfe2ae9...
SELECT ? FROM `projet` . `maintenance` LIMIT ?	NULL	26	26	100.0000	0	0.0000	2024-06-28 01:35:54.144838	2024-06-28 01:41:23.506698	ae0df1d3e4dafdffacb590bd9f736324c834857ed5265ec18d...
SELECT ? FROM `projet` . `productivite` LIMIT ?	NULL	24	24	100.0000	0	0.0000	2024-06-28 01:33:17.788377	2024-06-28 01:41:39.294501	30fe0b7934e4ed9002b83824cb77fe71b8ad06519150970606...
SELECT ? FROM `projet` . `ventas` LIMIT ?	NULL	24	24	100.0000	0	0.0000	2024-06-28 01:31:47.619940	2024-06-28 01:40:32.972224	c05f363742b04a7461158c4e01040948a75e137ceede3bfc55...
SELECT ? FROM `projet` . `taux_change` LIMIT ?	NULL	19	19	100.0000	0	0.0000	2024-06-28 01:36:18.132417	2024-06-28 01:40:19.637980	ed6759c9d390441f33868e976f9770ea119bf8d97ac5f3b1ae...
SELECT ? FROM `projet` . `taux_article` LIMIT ?	NULL	18	18	100.0000	0	0.0000	2024-06-28 01:33:30.004885	2024-06-28 01:40:20.998133	2369bc143c25c37be1d52396d03750724faed6cd013f068b7c...
SELECT ? FROM `projet` . `taux_service` LIMIT ?	NULL	18	18	100.0000	0	0.0000	2024-06-28 01:33:33.987900	2024-06-28 01:40:24.142385	9083265a90fcbf722799b93203a641ce25969bf11ad8fa1033...
SELECT ? FROM `projet` . `utilisateurs` LIMIT ?	NULL	18	18	100.0000	0	0.0000	2024-06-28 01:33:41.039729	2024-06-28 01:40:27.337670	9f71bcc781ae8230c015d2cb894c9530258624d9459db0c12f...
SELECT ? FROM `projet` . `service` LIMIT ?	NULL	18	18	100.0000	0	0.0000	2024-06-28 01:36:31.685853	2024-06-28 01:39:58.064200	6300ba81cf245e6dfd015c02b0425b2f1c174ced1a437786d5...
SELECT ? FROM `projet` . `chiffre_affaire` LIMIT ?	NULL	12	12	100.0000	0	0.0000	2024-06-28 01:34:05.961868	2024-06-28 01:35:12.872188	76b153dddb5a820df0f422e0e09d946e9e22d308be08b8d1da...
SELECT ? FROM `bd_registro` . `tipo` LIMIT ?	NULL	8	8	100.0000	0	0.0000	2024-06-28 01:31:27.602637	2024-06-28 01:31:41.851061	f1f91eb4e734b17fb572ea9c3f832c8696c92591122e04eae2...

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view

phpMyAdmin Demo Server: Git information missing!