MYSQL Tutorial

📝 Basic MySQL Commands — Overview

Here’s a quick overview of common MySQL commands you will use to manage databases, tables, and data:

1. Creating and Managing Databases

• CREATE DATABASE db_name; — Create a new database.
• USE db_name; — Select a database to work on.
• SHOW DATABASES; — List all databases.
• DROP DATABASE db_name; — Delete a database.

2. Creating and Managing Tables

• CREATE TABLE table_name (column1 datatype, column2 datatype, ...); — Create a new table.
• SHOW TABLES; — List all tables in the current database.
• DESCRIBE table_name; — Show the structure of a table.
• DROP TABLE table_name; — Delete a table.

3. Inserting, Updating, and Deleting Data

• INSERT INTO table_name (col1, col2) VALUES (val1, val2); — Add new data.
• SELECT * FROM table_name; — Retrieve all data.
• UPDATE table_name SET col1 = val1 WHERE condition; — Modify existing data.
• DELETE FROM table_name WHERE condition; — Remove data.

4. Querying Data

• SELECT col1, col2 FROM table_name WHERE condition; — Select specific columns with filters.
• ORDER BY col1 ASC|DESC; — Sort results ascending or descending.
• LIMIT n; — Limit the number of rows returned.