Before creating the table, you need to specify which database you are using in MYSQL.
Are you interested in learning SQL from the basics! Refer to this video on SQL provided by Intellipaat:
If in case the database does not exist, then you should create it as:
CREATE DATABASE db_name;
Which needs to be followed by: