MYSQL

 MYSQL Cheat Sheet 

Here's a cheat sheet summarizing some of the common MySQL commands and syntax:

sql

-- MySQL Cheat Sheet

-- Connect to MySQL Server:
mysql -u username -p

-- Create Database:
CREATE DATABASE database_name;

-- Use Database:
USE database_name;

-- Create Table:
CREATE TABLE table_name (
    column1 datatype constraints,
    column2 datatype constraints,
    ...
);

-- Insert Data into Table:
INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

-- Select Data from Table:
SELECT column1, column2, ...
FROM table_name
WHERE condition;

-- Update Data in Table:
UPDATE table_name
SET column = value
WHERE condition;

-- Delete Data from Table:
DELETE FROM table_name
WHERE condition;

-- Create Index:
CREATE INDEX index_name
ON table_name (column1, column2, ...);

-- Create Primary Key:
ALTER TABLE table_name
ADD PRIMARY KEY (column);

-- Create Foreign Key:
ALTER TABLE child_table_name
ADD FOREIGN KEY (column)
REFERENCES parent_table_name (column);

-- Join Tables:
SELECT columns
FROM table1
JOIN table2
ON table1.column = table2.column;

-- Aggregate Functions:
SELECT COUNT(column)       -- Count number of rows
SELECT SUM(column)         -- Sum of values in a column
SELECT AVG(column)         -- Average of values in a column
SELECT MAX(column)         -- Maximum value in a column
SELECT MIN(column)         -- Minimum value in a column

-- Grouping and Filtering:
SELECT column1, aggregate_function(column2)
FROM table_name
GROUP BY column1
HAVING condition;

-- Sorting:
SELECT columns
FROM table_name
ORDER BY column ASC|DESC;

-- Limiting Results:
SELECT columns
FROM table_name
LIMIT number;

-- Joins:
INNER JOIN table2 ON condition      -- Returns matching rows from both tables
LEFT JOIN table2 ON condition       -- Returns all rows from the left table and matching rows from the right table
RIGHT JOIN table2 ON condition      -- Returns all rows from the right table and matching rows from the left table
FULL JOIN table2 ON condition       -- Returns all rows when there is a match in either the left or right table

-- Backup and Restore:
mysqldump -u username -p database_name > backup.sql    -- Create a backup
mysql -u username -p database_name < backup.sql         -- Restore from a backup

-- Exit MySQL:
EXIT;

This cheat sheet covers some of the commonly used MySQL commands and syntax for managing databases, tables, data manipulation, querying, and basic administration tasks. It serves as a handy reference for quick look-ups and reminders while working with MySQL databases.