Basic MySQL Commands

Connecting to MySQL

mysql -u username -p

Showing Databases

SHOW DATABASES;

Creating a Database

CREATE DATABASE database_name;

Selecting a Database

USE database_name;

Showing Tables in a Database

SHOW TABLES;

Creating a Table

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

Showing Columns in a Table

SHOW COLUMNS FROM table_name;

Inserting Data into a Table

INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3);

Selecting Data from a Table

SELECT column1, column2
FROM table_name;

Updating Data in a Table