MySQL Tutorial - Database & Tables
🏗️ Database Aur Tables
🌟 Excel Sheet Analogy:
📊 Excel File = Database
📄 Sheet = Table
📋 Column Headers = Fields
📝 Rows = Records/Data
📝 Database vs Table
| Database | Table |
|---|---|
| Container | Actual data |
| school | students, teachers |
| shop | products, orders |
| hospital | patients, doctors |
🎯 Table Structure Example
Students Table
| id | name | age | class |
|----|---------|-----|-------|
| 1 | Rohan | 15 | 10th |
| 2 | Simran | 16 | 11th |
| 3 | Amit | 15 | 10th |Example
CREATE DATABASE school;
USE school;
CREATE TABLE students (
id INT PRIMARY KEY,
name VARCHAR(50),
age INT
);