CRUD

From BC$ MobileTV Wiki
Jump to: navigation, search

Create Read Update Delete (commonly abbreviated as CRUD) is a basic paradigm and straight-forward approach to building applications that create/consume various data.


CRUD Operations

Create

Add a new value.

SQL:

CREATE TABLE _____ ;


Read

View a value.

SQL:

SELECT * FROM _____ ;


Update

Modify a value.

SQL:

UPDATE _____ VALUES (val1,val2,...,val n) WITH (__,__,...,__);


Delete

Remove a value completely.

SQL:

DELETE FROM _____;




Tutorials


External Links

See Also

REST | Web Services | Database | MySQL