Before creating the table, you need to specify which database you are using in MYSQL.
USE db_name;
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:
USE db_name;