crud operations in mysql code example
Example: crud operations in mysql
-- (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