A MySQL database table is created by issuing this query :
CREATE TABLE IF NOT EXISTS table-name( col type , col type ) ;
The statement in this query must be followed by parentheses containing a comma-separated list of column definitions - defining the name of each table column
and the type of data that column may contain. For example a table "fruit" table might contain three columns named "id" , "name" and "color".
INT could specify that the "id" column may only contain integer values
and the TEXT keyword could specify that the "name" and "color" columns may only contain text values.

The query EXPLAIN table-name ; defines the format of any table.

A table may also be deleted form a database using
DROP TABLE IF EXISTS table-name ;

Issuing a query to create a table with many columns can be difficult to type accurately at the mysql> command prompt
so it is better to create the query as an SQL text file first and then implement the query using the SOURCE keyword
at the command prompt to identify the path to the file in the chosen folder.