MYSQL Introduction
📌 Introduction to MySQL
MySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL).
It is one of the most popular databases used in web applications.
🔹 Full Form of MySQL
MySQL stands for "My Structured Query Language". It was named after the daughter of co-founder Monty Widenius.
🔥 Features of MySQL
- ✅ Open-source and free
- ✅ Fast and reliable
- ✅ Supports multiple storage engines
- ✅ Cross-platform compatibility
- ✅ High performance and scalability
📌 Basic MySQL Commands
To create a new database in MySQL:
CREATE DATABASE mydatabase;
To show all databases:
SHOW DATABASES;
To create a table for storing users:
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(100) UNIQUE
);