MYSQL Tutorial

🔍 Introduction to MySQL

MySQL is an open-source relational database management system (RDBMS) based on Structured Query Language (SQL). It is one of the most popular databases used for managing and storing data in web applications.

🔧 What Can You Do with MySQL?

• Create databases and tables
• Insert, update, and delete data
• Run powerful queries to retrieve data
• Manage user access and security
• Establish relationships between tables (via foreign keys)

📦 Basic Database Terms

• Database: A collection of related data.
• Table: A structure inside a database that stores rows and columns of data.
• Row: A record or entry in the table.
• Column: A field that contains specific data for every record.

📘 Basic SQL Commands

-- Create a new database
CREATE DATABASE school;

-- Use the database
USE school;

-- Create a table
CREATE TABLE students (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  age INT
);

-- Insert data
INSERT INTO students (id, name, age) VALUES (1, 'Amit', 18);

-- Retrieve data
SELECT * FROM students;
  

🧪 Try It Yourself (Example Visual)

🔐 MySQL in Web Development

MySQL is commonly used with server-side languages like PHP or Node.js to power web apps. It helps store user data, blog posts, orders, and more.

📱 Pro Tips

• phpMyAdmin is a visual interface to manage MySQL databases easily without writing code.
• Use LIMIT in queries to control how much data you retrieve.
• Keep regular backups of your databases to avoid data loss.

✅ Summary

MySQL is the backbone of many data-driven applications. Learning how to use it gives you the power to create robust, scalable, and efficient backends for any kind of project.