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';