The table is a collection of rows and columns. when you create a table then column must be defined with the datatype.
Syntax:-
CREATE TABLE tableName( field1 datatype, field2 datatype, field3 datatype, field4 datatype)
Example:-
Now we are creating an employees table
CREATE TABLE employees( id INT NOT NULL, first_name varchar(255) NOT NULL, last_name varchar(255), email varchar(50) NOT NULL, address varchar(255) NOT NULL, PRIMARY KEY (id) )
Now, after created successfully then check the result through
DESC employees
+------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | id | int(11) | NO | PRI | NULL | | | first_name | varchar(255) | NO | | NULL | | | last_name | varchar(255) | YES | | NULL | | | email | varchar(50) | NO | | NULL | | | address | varchar(255) | NO | | NULL | | +------------+--------------+------+-----+---------+-------+ 5 rows in set (0.06 sec)