This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
webseite:mysql:basic [2014/05/27 15:04] – lunetikk | webseite:mysql:basic [2014/11/30 03:52] – lunetikk | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== MySQL Basics ====== | ====== MySQL Basics ====== | ||
- | ^Code^What it does^ | + | ==== Data Definition Language (DDL) ==== |
+ | |||
+ | ^^^ | ||
+ | | CREATE | ||
+ | | ALTER | alters / change the structure of the db | | ||
+ | | DROP | delete objects from the db | | ||
+ | |||
+ | ==== Data Manipulation Language (DML) ==== | ||
+ | |||
+ | ^^^ | ||
+ | | SELECT | ||
+ | | INSERT | ||
+ | | UPDATE | ||
+ | | DELETE | ||
+ | |||
+ | ===== Code examples ===== | ||
+ | ^ | ||
| SELECT * FROM Table WHERE Cell LIKE ' | | SELECT * FROM Table WHERE Cell LIKE ' | ||
| SELECT IdX FROM Table WHERE Cell LIKE ' | | SELECT IdX FROM Table WHERE Cell LIKE ' |