Database Operations

SHOW DATABASES;

View all databases in the server

CREATE DATABASE database_name;

Create a new database

USE database_name;

Switch to a specific database

DROP DATABASE database_name;

Delete a database

Table Operations

SHOW TABLES;

View all tables in the current database

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

Common SQL datatypes include:

Numeric Types:

• INT - Integer values (e.g., -2147483648 to 2147483647)
• TINYINT - Small integer (-128 to 127)
• BIGINT - Large integer values
• DECIMAL(p,s) - Exact decimal numbers (p=precision, s=scale)
• FLOAT/DOUBLE - Approximate decimal numbers