How To Create a Table in MYSQL

To create a table in mysql you must have a database.Database can contain one or more table an you will be able to create unlimited table in one database.But you have to know how to design a database and design table more than effective.
The syntax to create a table in database.follow this instruction

if you have a database

type this instruction

Use Database
Create table tablename

How To Create Database In Mysql

First step if you want to make a database in mysql you should be create your database. the syntax to create a database is very simple just you type Create Database

For example : Create database shop