🐬
Basics

What is MySQL?

Relational Database Management System
💡 MySQL, EK, "ORGANIZED, FILING, SYSTEM" hai, JAISA, EK, WELL-MAINTAINED, OFFICE, mein, HOTA, hai — HAR, CABINET, (TABLE) ka, EK, FIXED, STRUCTURE, hai, aur, CABINETS, EK, DUSRE, se, RELATIONSHIPS, (FOREIGN, KEYS) SE, JUDE, HOTE, HAIN.

MySQL, EK, OPEN-SOURCE, RELATIONAL, DATABASE, MANAGEMENT, SYSTEM, (RDBMS) hai — DATA, ko, STRUCTURED, TABLES, (ROWS aur COLUMNS) mein, STORE, karta hai. YE, DUNIYA, ki, MOST, POPULAR, DATABASES, mein, se, EK, hai, ESPECIALLY, WEB, APPLICATIONS, ke, liye.

SQL (Structured Query Language), MySQL, ke, saath, INTERACT, karne, ka, STANDARD, WAY, hai — QUERIES, LIKHKE, DATA, INSERT, RETRIEVE, UPDATE, aur, DELETE, kiya, jaata hai.

-- MySQL shell mein, EK, database, banaна:
CREATE DATABASE myapp;
USE myapp;

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(100) NOT NULL,
  email VARCHAR(100) UNIQUE
);
🐬
MySQL, EK, "ORGANIZED, FILING, SYSTEM" hai, JAISA, EK, WELL-MAINTAINED, OFFICE, mein, HOTA, hai — HAR, CABINET, (TABLE) ka, EK, FIXED, STRUCTURE, hai, aur, CABINETS, EK, DUSRE, se, RELATIONSHIPS, (FOREIGN, KEYS) SE, JUDE, HOTE, HAIN.
1 / 2
⚡ Quick Recap
  • MySQL = open-source RDBMS, structured tables mein, DATA, store, karta, hai
  • SQL = standard query language, MySQL, ke, saath, interact, karne, ke, liye
  • Web applications, ke, liye, EXTREMELY, popular, hai
Is page mein (2 subtopics)

MySQL, 1995, mein, RELEASE, HUI, thi — 2008, mein, Sun Microsystems, ne, ISE, ACQUIRE, kiya, aur, 2010, mein, Oracle, ne, Sun, ko, ACQUIRE, kiya. Aaj, MySQL, Oracle, ke, under, MAINTAIN, hoti, hai, LEKIN, OPEN-SOURCE, (GPL, license) rehti, hai.

💡Tip: MariaDB, EK, "fork" hai, MySQL, ka, — ORIGINAL, MySQL, creator, dwara, hi, banaya, gaya, jab, WOH, Oracle, ke, MySQL, ke, future, ko, LEKAR, CONCERNED, the.

MySQL, aur, PostgreSQL, dono, POPULAR, OPEN-SOURCE, RDBMS, HAIN — MySQL, GENERALLY, FASTER, reads, ke, liye, aur, SIMPLER, hai. PostgreSQL, MORE, ADVANCED, features, (jaise, better, JSON, support, custom, types) deta, hai, aur, STRICTER, SQL, standard, compliance, follow, karta, hai.

// Dono, POPULAR, hain — choice, aksar, TEAM, ki, familiarity, aur, specific, feature, needs, par, depend, karta, hai