MYSQL Tutorial

📌 Rows and Columns in MySQL

In a MySQL table:

• 🔹 Columns define the structure — they are the fields like id, name, age.
• 🔹 Rows are the records — each row contains values for each column.

📁 Example: students Table

🧩 Understanding Columns

• Columns are like headers in Excel.
• Each column has a name and a data type.
• Example: name VARCHAR(50) → column for names up to 50 characters.

🧩 Understanding Rows

• Rows hold the actual data.
• Each row is a full record (like 1 student’s data).
• Rows are added using the INSERT INTO statement.

🛠️ Insert Example (Row)

INSERT INTO students (name, age, city)
VALUES ('Suman', 22, 'Bangalore');