learn-mysql
v1.2.0
Published
Complete MySQL guide with resources for learning.
Downloads
8
Readme
Learn MySQL
Here's a basic MySQL cheat sheet covering some common commands and syntax:
Basic Commands:
Connect to MySQL:
mysql -u username -p
Show Databases:
SHOW DATABASES;
Use a Database:
USE database_name;
Show Tables:
SHOW TABLES;
Show Table Structure:
DESCRIBE table_name;
Create Database:
CREATE DATABASE database_name;
Create Table:
CREATE TABLE table_name ( column1 datatype, column2 datatype, ... );
Insert Data:
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
Select Data:
SELECT column1, column2, ... FROM table_name WHERE condition;
Update Data:
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
Delete Data:
DELETE FROM table_name WHERE condition;
Drop Table:
DROP TABLE table_name;
Drop Database:
DROP DATABASE database_name;
Advanced Commands:
Joins:
SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;
Group By:
SELECT column1, COUNT(*) FROM table_name GROUP BY column1;
Order By:
SELECT * FROM table_name ORDER BY column_name;
Aliases:
SELECT column_name AS alias_name FROM table_name;
Aggregate Functions:
SELECT COUNT(column_name) FROM table_name;
Subqueries:
SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM another_table);
Views:
CREATE VIEW view_name AS SELECT column1, column2 FROM table_name WHERE condition;
Remember to replace placeholders like username
, database_name
, table_name
, etc., with your actual values. This cheat sheet should help you get started with basic MySQL commands and operations.