This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
webseite:mysql:basic [2017/03/01 12:50] – external edit 127.0.0.1 | 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 42: | Line 42: | ||
\\ | \\ | ||
\\ | \\ | ||
- | ~~DISCUSSION~~ | + | ~~DISCUSSION:closed~~ |