About SHOW

Overview of the SHOW statement syntax. Learn how to use patterns and WHERE clauses to filter output from various SHOW statements.

SHOW provides information about various aspects of MariaDB Server. A list of the various SHOW statements is here.

The general syntax is:

SHOW LIKE 'pattern' | WHERE expr

The LIKE and WHERE clauses make sense only for particular SHOW statements, though. See Extended SHOW for what SHOW statements benefit from using those clauses.

If the syntax for a given SHOW statement includes LIKE 'pattern' , 'pattern' is a string that can contain the SQL % and _ wildcard characters. The pattern is useful for restricting statement output to matching values.

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}