MySQL Complete Guide 🗄️

Database + SQL + Queries

1. Introduction

MySQL is a relational database used to store and manage data in tables using SQL queries. 

-- Start MySQL
mysql -u root -p

2. Database Commands

CREATE DATABASE school;

USE school;

3. Create Table

CREATE TABLE students (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);

4. Insert Data

INSERT INTO students VALUES (1, 'Sasank', 18);

5. Select Data

SELECT * FROM students;
SELECT name FROM students;

6. WHERE Condition

SELECT * FROM students WHERE age > 18;

7. Update Data

UPDATE students
SET age = 20
WHERE id = 1;

8. Delete Data

DELETE FROM students WHERE id = 1;

9. Sorting

SELECT * FROM students ORDER BY age DESC;

10. Functions

SELECT COUNT(*) FROM students;
SELECT MAX(age) FROM students;

11. JOIN

SELECT students.name, marks.score
FROM students
JOIN marks ON students.id = marks.id;

12. Mini Project Idea

School Database:
- Students table
- Marks table
- Attendance system