crud operations syntax in sql code example
Example 1: sql crud
INSERT INTO my_table (my_col) VALUES ('Hello');
SELECT my_col FROM my_table WHERE my_id = 33;
UPDATE my_table SET my_col = 'Holla' WHERE my_id= 33;
DELETE FROM my_table WHERE my_id = 33;
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.