MySQL Guide

MySQLPopular Relational Database

Learn MySQL fundamentals, SQL queries, joins, indexes, transactions, and building reliable database applications.

Contents

MySQL Basics

MySQL is the world's most popular open-source relational database. Learn table creation, CRUD operations, and data types.

sql
-- Create Database
CREATE DATABASE mydb;
USE mydb;

-- Create Table
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    age INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB;

-- Insert Data
INSERT INTO users (name, email, age) 
VALUES ('John Doe', 'john@example.com', 30);

-- Select Data
SELECT * FROM users;
SELECT name, email FROM users WHERE age > 25;

-- Update Data
UPDATE users SET age = 31 WHERE id = 1;

-- Delete Data
DELETE FROM users WHERE id = 1;