What is the difference between SHOW and SELECT

Answer 1

https://mariadb.com/kb/en/show/
https://mariadb.com/kb/en/select/

Answer 2

SHOW provides information about the database itself, tables, columns, etc. The SELECT statement is used to select data from the database.