crud
Create , Read , Update , Delete
CRUD is an acronym for the four basic types of SQL commands: Create , Read , Update , Delete . Most applications have some kind of CRUD functionality, and we can assume that every programmer had to deal with CRUD at some point. A CRUD application is one that uses forms to get data into and out of a database.
3.83
6
-- (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
Thank you!
6
0
Are there any code examples left?
New code examples in category SQL
-
SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
-
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
-
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
-
SQL 2022-03-27 19:20:41 sql is not null
-
SQL 2022-03-27 19:20:39 sql group by error
-
SQL 2022-03-27 18:35:10 replace null with 0 in sql
-
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
-
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
-
SQL 2022-03-27 16:45:07 kill a pid redshift
-
SQL 2022-03-27 16:00:09 joins in sql server