MySQL Cheatsheet
๐ MySQL Basics -- Login to MySQL
mysql -u root -p
-- Show all databases
SHOW DATABASES;
-- Create new database
CREATE DATABASE mydb;
-- Use a database
USE mydb;
-- Show tables
SHOW TABLES;
-- Describe table structure
DESCRIBE users;
๐ฆ Tables & Data -- Create table
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100) UNIQUE,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
-- Insert data
INSERT INTO users (name, email) VALUES
('Alice', 'alice@example.com'),
('Bob', 'bob@example.com');
-- Select data
SELECT * FROM users;
SELECT name, email FROM users WHERE id = 1;
-- Update data
UPDATE users SET name = 'Alice Smith' WHERE id = 1;
-- Delete data
DELETE FROM users WHERE id = 2;
๐ Joins -- Inner Join
SELECT users.name, orders.product
FROM users
INNER JOIN orders ON users.id = orders.user_id;
-- Left Join
SELECT users.name, orders.product
FROM users
LEFT JOIN orders ON users.id = orders.u…