Creating and Dropping Databases and Tables in MySQL

CREATE DATABASE

CREATE DATABASE inventory_db;

CREATE TABLE

CREATE TABLE products (
  id INT PRIMARY KEY,
  name VARCHAR(100),
  price DECIMAL(10,2)
);

DROP TABLE

DROP TABLE products;

DROP DATABASE

DROP DATABASE inventory_db;