MySQL.js

//Learn MySql 
// Learn MySQL
// MySQL is a widely used relational database management system (RDBMS).

// MySQL is free and open-source.

// MySQL is ideal for both small and large applications.


// Examples in Each Chapter
// With our online MySQL editor, you can edit the SQL statements, and click on a button to view the result.


// What is RDBMS?

// 👉 RDBMS (Relational Database Management System) ek aisa system hai jo data ko tables (rows aur columns) me store karta hai aur unke beech relation banata hai.
// RDBMS stands for Relational Database Management System.

// RDBMS is a program used to maintain a relational database.

// RDBMS is the basis for all modern database systems such as MySQL, Microsoft SQL Server, Oracle, and Microsoft Access.

// RDBMS uses SQL queries to access the data in the database.


// What is a Database Table?
// A table is a collection of related data entries, and it consists of columns and rows.

// A column holds specific information about every record in the table.

// A record (or row) is each individual entry that exists in a table.

// Look at a selection from the Northwind "Customers" .




// What is a Relational Database?
// A relational database defines database relationships in the form of tables. The tables are related to each other - based on data common to each.

// Look at the following three tables "Customers", "Orders", and "Shippers" from the Northwind database:



// Some of The Most Important SQL Commands

// SELECT - extracts data from a database
// UPDATE - updates data in a database
// DELETE - deletes data from a database
// INSERT INTO - inserts new data into a database
// CREATE DATABASE - creates a new database
// ALTER DATABASE - modifies a database
// CREATE TABLE - creates a new table
// ALTER TABLE - modifies a table   
// DROP TABLE - deletes a table
// CREATE INDEX - creates an index (search key)
// DROP INDEX - deletes an index