MySQL is a popular open-source relational database management system used for storing and managing data. This cheatsheet provides a quick reference guide for common MySQL commands and operations.
| Command | Description |
|---|---|
mysql -u [username] -p |
Log in to MySQL as a specific user |
SHOW DATABASES; |
Display a list of available databases |
USE [database]; |
Switch to a specific database |
SHOW TABLES; |
Show tables in the current database |
DESCRIBE [table]; |
Display the structure of a table |
| Command | Description |
|---|---|
CREATE DATABASE [name]; |
Create a new database |
CREATE TABLE [table]...; |
Create a new table |
ALTER TABLE [table]...; |
Modify the structure of a table |
DROP DATABASE [name]; |
Delete a database |
DROP TABLE [table]; |
Delete a table |
| Command | Description |
|---|---|
INSERT INTO [table]...; |
Insert new records into a table |
UPDATE [table]...; |
Update existing records in a table |
DELETE FROM [table]...; |
Delete records from a table |
SELECT [columns] FROM [table]; |
Retrieve data from a table |
| Command | Description |
|---|---|
SELECT * FROM [table]; |
Retrieve all columns from a table |
SELECT [columns] FROM [table] WHERE [condition]; |
Filter data based on a condition |
ORDER BY [column] [ASC/DESC]; |
Sort the result set |
LIMIT [number]; |
Limit the number of rows returned |
| Command | Description |
|---|---|
WHERE [condition]; |
Filter records based on a condition |
AND |
Combine multiple conditions with AND |
OR |
Combine multiple conditions with OR |
IN ([values]); |
Filter records where a column is in a list |
| Command | Description |
|---|---|
JOIN [table] ON [condition]; |
Combine rows from two or more tables |
INNER JOIN [table] ON [condition]; |
Return only matching rows |
LEFT JOIN [table] ON [condition]; |
Return all rows from the left table |
RIGHT JOIN [table] ON [condition]; |
Return all rows from the right table |
FULL JOIN [table] ON [condition]; |
Return all rows when there is a match |
| Command | Description |
|---|---|
CREATE INDEX [index] ON [table] ([columns]); |
Create an index on one or more columns |
DROP INDEX [index] ON [table]; |
Remove an index from a table |
| Command | Description |
|---|---|
START TRANSACTION; |
Begin a new transaction |
COMMIT; |
Save the changes made during the transaction |
ROLLBACK; |
Undo the changes made during the transaction |
This cheatsheet covers a wide range of MySQL commands, from basic database interaction to advanced querying and transaction management. Use it as a quick reference guide to enhance your productivity when working with MySQL databases.