What are the existing SQL operators?

SQL operators are a set of instructions used to perform operations on data in a database. They allow selecting, inserting, updating, deleting data, and managing database structure.

Main categories of SQL operators:

• DDL (Data Definition Language): Define or modify database structure.
  • CREATE: Create new database objects (tables, indexes, views, etc.).
  • ALTER: Modify existing database objects.
  • DROP: Drop database objects.
  • TRUNCATE: Quickly delete all rows from a table.
• DML (Data Manipulation Language): Manipulate data within tables.
  • SELECT: Retrieve data.
  • INSERT: Add new rows.
  • UPDATE: Modify existing rows.
  • DELETE: Remove rows.
• DCL (Data Control Language): Manage access rights.
  • GRANT: Grant access rights.
  • REVOKE: Revoke access rights.
• TCL (Transaction Control Language): Manage transactions.
  • COMMIT: Save changes.
  • ROLLBACK: Roll back changes.
  • SAVEPOINT: Set a savepoint within a transaction.

Example usage of SELECT:

-- Select all columns from "users" table
SELECT *
FROM users;

Example usage of INSERT:

-- Insert a new row into "products" table
INSERT INTO products (product_name, price)
VALUES ('Laptop', 1200.00);