Sobes.tech
Junior — Middle

What main operators are used in SQL for simple data manipulations?

sobes.tech AI

Answer from AI

Main SQL operators for simple data manipulations:

  • SELECT — retrieving data from a table.
  • INSERT — adding new records.
  • UPDATE — updating existing records.
  • DELETE — deleting records.

Example:

-- Add a new record
INSERT INTO users (name, age) VALUES ('Ivan', 30);

-- Update user's age
UPDATE users SET age = 31 WHERE name = 'Ivan';

-- Get all users
SELECT * FROM users;

-- Delete a user
DELETE FROM users WHERE name = 'Ivan';