learn-mysql v1.2.0

Learn MySQL

Here's a basic MySQL cheat sheet covering some common commands and syntax:

Basic Commands:

1. Connect to MySQL:

   mysql -u username -p

2. Show Databases:

   SHOW DATABASES;

3. Use a Database:

   USE database_name;

4. Show Tables:

   SHOW TABLES;

5. Show Table Structure:

   DESCRIBE table_name;

6. Create Database:

   CREATE DATABASE database_name;

7. Create Table:

   CREATE TABLE table_name (
       column1 datatype,
       column2 datatype,
       ...
   );

8. Insert Data:

   INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

9. Select Data:

   SELECT column1, column2, ... FROM table_name WHERE condition;

10. Update Data:

    UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

11. Delete Data:

    DELETE FROM table_name WHERE condition;

12. Drop Table:

    DROP TABLE table_name;

13. Drop Database:

    DROP DATABASE database_name;

Advanced Commands:

1. Joins:

   SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;

2. Group By:

   SELECT column1, COUNT(*) FROM table_name GROUP BY column1;

3. Order By:

   SELECT * FROM table_name ORDER BY column_name;

4. Aliases:

   SELECT column_name AS alias_name FROM table_name;

5. Aggregate Functions:

   SELECT COUNT(column_name) FROM table_name;

6. Subqueries:

   SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM another_table);

7. 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.