crud operations in sql with examples
Example 1: sql crud
-- (C)reate (R)ead (U)pdate (D)elete
INSERT INTO my_table (my_col) VALUES ('Hello'); -- (C)reate
SELECT my_col FROM my_table WHERE my_id = 33; -- (R)ead
UPDATE my_table SET my_col = 'Holla' WHERE my_id= 33; -- (U)pdate
DELETE FROM my_table WHERE my_id = 33; -- (D)elete
Example 2: crud sql
CRUD is an acronym that stands for CREATE, READ, UPDATE, and DELETE.
These are the four most basic operations that can be performed with most traditional database systems and they are the backbone for interacting with any database.