What is the difference between show and select?

Question

Difference between show and select?

Answer 1

* SHOW
Is used to show various types of information related with the database and/or its contents or metadata.

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

* SELECT
Is used to select columns(a.k.a fields) from a table, or multiple tables.

https://mariadb.com/kb/en/selecting-data/
https://www.w3schools.com/sql/sql_select.asp

Answer 2

Have you tried to search the net for a clarification to your doubt?

Answer 3

I have another doubt

Answer 4

How to create normalisation tables

Answer 5

In normalisation for example if I want to create 2 tables then I need to create two different tables ?is it right