What is an SQL operator?

SQL Operator — is a set of instructions used to perform operations with data in a database. They allow selecting, inserting, updating, and deleting data, as well as managing the database structure.

Main categories of SQL operators:

• DDL (Data Definition Language): Define or modify the database structure.
  • CREATE: Creating database objects (tables, indexes, views).
  • ALTER: Modifying existing objects.
  • DROP: Deleting database objects.
  • TRUNCATE: Quickly removing all rows from a table.
• DML (Data Manipulation Language): Manipulate data in the database.
  • SELECT: Retrieve data.
  • INSERT: Insert new rows.
  • UPDATE: Modify existing rows.
  • DELETE: Delete rows.
• DCL (Data Control Language): Manage access rights.
  • GRANT: Grant access rights.
  • REVOKE: Revoke access rights.
• TCL (Transaction Control Language): Manage transactions.
  • COMMIT: Save transaction changes.
  • ROLLBACK: Cancel transaction changes.
  • SAVEPOINT: Set a rollback point within a transaction.

Example of using the SELECT operator:

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

Example of using the INSERT operator:

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