Chapter :-5 (English)

1. MySQL

MySQL

MySQL is an open-source relational database management system (RDBMS) used to store, organize, and manage data.

It uses SQL (Structured Query Language) to create, read, update, and delete data in tables made up of rows and columns.
MySQL is widely used in web applications, software systems, and enterprise projects because it is fast, reliable, and easy to use.

In simple words:
👉 MySQL is software that helps you store and manage data in an organized way.

Looks like you’re asking about types of SQL commands 🙂
Here’s a clear, exam-friendly breakdown:

1. Data Definition Commands (DDL – Data Definition Language)

These commands define or change the structure of database objects like tables, schemas, etc.

Common DDL commands:

· CREATE – creates a new table, database, view, etc.

· ALTER – modifies an existing table structure

· DROP – deletes a table or database permanently

· TRUNCATE – removes all records from a table (structure remains)

Example:

CREATE TABLE Student (

  id INT,

  name VARCHAR(50)

);

2. Data Manipulation Commands (DML – Data Manipulation Language)

These commands are used to add, change, or remove data stored in tables.

Common DML commands:

· INSERT – adds new records

· UPDATE – modifies existing records

· DELETE – removes records

Example:

INSERT INTO Student VALUES (1, 'Asha');

3. Data Retrieval Commands (DQL – Data Query Language)

These commands are used to retrieve data from the database.

Main DQL command:

· SELECT – fetches data from one or more tables

Example:

SELECT * FROM Student;

Quick Summary Table

Type	Purpose	Commands
DDL	Defines database structure	CREATE, ALTER, DROP, TRUNCATE
DML	Manipulates data	INSERT, UPDATE, DELETE
DQL	Retrieves data	SELECT

If you want this tailored for exam answers, notes, or with more examples, just say the word 👍

A network error occurred. Please check your connection and try again. If this issue persists please contact us through our help center at help.openai.com.