How to create a database in mysql

create database name

use name

show tables

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... );