sqlStatements.txt

>>>>>>>>>>1. DML (Data Manipulation Language)<<<<<<<<<<<<<<<

DML statements are used to manipulate the data within the database. 
These operations allow users to insert, update, delete, and retrieve data from the tables.

** INSERT: Adds new rows of data to a table.
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

** UPDATE: Modifies existing data within a table.
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

** DELETE: Removes existing rows from a table.
DELETE FROM table_name WHERE condition;

** SELECT: Retrieves data from the database.
SELECT column1, column2, ... FROM table_name WHERE condition;

>>>>>>>>>>>2. DDL (Data Definition Language)<<<<<<<<<<<<<<<<<<

DDL statements are used to define and manage the database schema. 
These commands create, alter, and delete database objects such as tables, indexes, and views.

** CREATE: Creates new database objects (e.g., tables, indexes).
            CREATE TABLE table_name (
                column1 datatype constraint,
                column2 datatype constraint,
                ...
            );

** ALTER: Modifies the structure of existing database objects.
            ALTER TABLE table_name ADD column_name datatype constraint;
            ALTER TABLE table_name DROP COLUMN column_name;

** DROP: Deletes existing database objects.
                DROP TABLE table_name;

** TRUNCATE: Removes all rows from a table, resetting its storage.
                TRUNCATE TABLE table_name;

>>>>>>>>>>>>>3. DCL (Data Control Language)<<<<<<<<<<<<<<<<<<<<<<<<<<

DCL statements control access to the data within the database. 
These commands are used to grant and revoke privileges to users.

** GRANT: Provides specific privileges to users or roles.
GRANT SELECT, INSERT ON table_name TO user_name;


** REVOKE: Removes specific privileges from users or roles.
REVOKE SELECT, INSERT ON table_name FROM user_name;


>>>>>>>>>>>>>>>4. DQL (Data Query Language)<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

DQL statements are primarily used to query the database and retrieve data. The most common DQL command is:

** SELECT: Retrieves data from one or more tables.
SELECT column1, column2, ... FROM table_name WHERE condition;