MYSQL Tutorial

📊 Tables in MySQL

In MySQL, tables are where your data is actually stored. A table is a collection of rows and columns, similar to a spreadsheet. Each row is a record, and each column is a field or attribute.

📁 Example Table: students

🛠️ How to Create a Table

You can create a table in MySQL using the CREATE TABLE command:

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

📌 Explanation

• id INT AUTO_INCREMENT → Creates an auto-incrementing ID column
• name VARCHAR(50) → Stores names up to 50 characters
• PRIMARY KEY (id) → Makes id a unique identifier for each row

✅ Tips