Creating and Dropping Databases and Tables in MySQL

Create a Database

CREATE DATABASE school;

Create a Table

CREATE TABLE students (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  age INT
);

Drop

DROP DATABASE school;
DROP TABLE students;