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/11/30 03:52] – lunetikk | webseite:mysql:basic [2015/06/10 11:44] – lunetikk | ||
---|---|---|---|
Line 15: | Line 15: | ||
| UPDATE | | UPDATE | ||
| DELETE | | DELETE | ||
+ | |||
+ | ===== Basics ===== | ||
+ | ^ Code ^ Function | ||
+ | | CREATE TABLE Personal (Lastname CHAR(50) Firstname CHAR(50) Rank VARCHAR(30) Salary (INT); | ||
+ | | INSERT INTO Personal (Lastname, Firstname) VALUES (' | ||
+ | | UPDATE Personal SET Salary=3200 WHERE Lastname = " | ||
+ | | DELETE FROM Personal WHERE Lastname = " | ||
+ | | DROP TABLE Personal; | ||
+ | | ALTER TABLE Personal ADD Gender CHAR (1); | Add a new column Gender | ||
+ | | SELECT Lastname, Firstname FROM Personal ORDER BY Lastname; | ||
+ | | SELECT Rank FROM Personal GROUP BY Rank; | Shows the ranks grouped | ||
+ | | SELECT COUNT(*) FROM table; | ||
+ | | SELECT * FROM table WHERE field LIKE ' | ||
+ | | SELECT a.name, a.age, b.address FROM table1 a, table2 b WHERE a.id = b.id; | You can use this instead of inner join | | ||
+ | |||
===== Code examples ===== | ===== Code examples ===== |