This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
webseite:mysql:basic [2015/06/10 11:44] – lunetikk | webseite:mysql:basic [2018/12/20 17:40] (current) – Discussion status changed lunetikk | ||
---|---|---|---|
Line 18: | Line 18: | ||
===== Basics ===== | ===== Basics ===== | ||
^ Code ^ Function | ^ Code ^ Function | ||
- | | CREATE TABLE Personal (Lastname CHAR(50) Firstname CHAR(50) Rank VARCHAR(30) Salary (INT); | + | | CREATE TABLE Personal (Lastname CHAR(50) Firstname CHAR(50) Rank VARCHAR(30) Salary (INT)); | Create table | |
| INSERT INTO Personal (Lastname, Firstname) VALUES (' | | INSERT INTO Personal (Lastname, Firstname) VALUES (' | ||
| UPDATE Personal SET Salary=3200 WHERE Lastname = " | | UPDATE Personal SET Salary=3200 WHERE Lastname = " | ||
Line 39: | Line 39: | ||
| UPDATE `DB`.`Table` SET `Cell1` = ' | | UPDATE `DB`.`Table` SET `Cell1` = ' | ||
| INSERT INTO Table (Cell1, Cell2) VALUES (' | | INSERT INTO Table (Cell1, Cell2) VALUES (' | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | ~~DISCUSSION: |