Basic SQL Commands

Basic SQL Commands
The SQL SHOW statement displays information contained in the database and its tables. This helpful tool lets you keep track of your database contents and remind yourself about the structure of your tables.
For example, the SHOW DATABASES command lists the databases managed by the server. SHOW DATABASES
Throughout the tutorial we will be using the MySQL engine and the PHPMyAdmin tool to run SQL queries.
Basic SQL Commands
The SHOW TABLES command is used to display all of the tables in the currently selected MySQL database.

Basic SQL Commands SHOW COLUMNS displays information about the columns in a given table.
The following example displays the columns in our customers table:.
SHOW COLUMNS FROM customers.

SHOW COLUMNS displays the following values for each table column:.
Field: column name.
Type: column data type.
Key: indicates whether the column is indexed.
Default: default value assigned to the column.
Extra: may contain any additional information that is available about a given column.