คำสั่ง SHOW ในระบบฐานข้อมูล MariaDB

SHOW เป็นคำสั่งสำหรับแสดงรายละเอียดข้อมูล (Information) ของ database, table, columns, field และ สถานะต่างๆ ของระบบทั้งหมด

Syntax

       SHOW AUTHORS
or    SHOW CHARACTER SET [like_or_where]
or    SHOW COLLATION [like_or_where]
or    SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [like_or_where]
or    SHOW CONTRIBUTORS
or    SHOW CREATE DATABASE db_name
or    SHOW CREATE EVENT event_name
or    SHOW CREATE PROCEDURE proc_name
or    SHOW CREATE TABLE tbl_name
or    SHOW CREATE TRIGGER trigger_name
or    SHOW CREATE VIEW view_name
or    SHOW DATABASES [like_or_where]
or    SHOW ENGINE engine_name {STATUS | MUTEX}
or    SHOW [STORAGE] ENGINES
or    SHOW ERRORS [LIMIT [offset,] row_count]
or    SHOW [FULL] EVENTS
or    SHOW FUNCTION CODE func_name
or    SHOW FUNCTION STATUS [like_or_where]
or    SHOW GRANTS FOR user
or    SHOW INDEX FROM tbl_name [FROM db_name]
or    SHOW INNODB STATUS
or    SHOW OPEN TABLES [FROM db_name] [like_or_where]
or    SHOW PLUGINS
or    SHOW PROCEDURE CODE proc_name
or    SHOW PROCEDURE STATUS [like_or_where]
or    SHOW PRIVILEGES
or    SHOW [FULL] PROCESSLIST
or    SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]
or    SHOW PROFILES
or    SHOW [GLOBAL | SESSION] STATUS [like_or_where]
or    SHOW TABLE STATUS [FROM db_name] [like_or_where]
or    SHOW TABLES [FROM db_name] [like_or_where]
or    SHOW TRIGGERS [FROM db_name] [like_or_where]
or    SHOW [GLOBAL | SESSION] VARIABLES [like_or_where]
or    SHOW WARNINGS [LIMIT [offset,] row_count]

เช่นใช้คำสั่ง SHOW CHARACTER SET LIKE 'latin%';

C:\>cd "Program Files\MariaDB 10.1\bin"

C:\Program Files\MariaDB 10.1\bin>mysql -u root -p
Enter password: ********
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.14-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW CHARACTER SET LIKE 'latin%';
+---------+------------------------------------+-------------------+--------+
| Charset | Description                         | Default collation | Maxlen |
+---------+-----------------------------------+-------------------+--------+
| latin1 | cp1252 West European          | latin1_swedish_ci |      1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci |      1 |
| latin5 | ISO 8859-9 Turkish               | latin5_turkish_ci |      1 |
| latin7 | ISO 8859-13 Baltic            | latin7_general_ci |      1 |
+---------+-----------------------------------+-------------------+--------+
4 rows in set (0.00 sec)

MariaDB [(none)]>