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
            );