Skip to content

Instantly share code, notes, and snippets.

@Mattia46
Last active November 3, 2015 14:33
Show Gist options
  • Select an option

  • Save Mattia46/5ceda0017560f98290ec to your computer and use it in GitHub Desktop.

Select an option

Save Mattia46/5ceda0017560f98290ec to your computer and use it in GitHub Desktop.
Details about CRUD!!

CRUD


CRUD stand for 'Create', 'Read', 'Update' and 'Delete'. Each function of CRUD represents a major function of working with relational database (SQL). SQL is a language made for managing data held for relational databases.

Example:

Create:

INSERT INFO table_name (:key => value);

Read

SELECT colum_name FROM table_name;

Update:

UPDATE table_name SET key = new_value WHERE key = old_value;

Delete:

DELETE FROM table_name WHERE key = old_value

Mattia & Alaan

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment