This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
webseite:mysql:basic [2014/06/05 15:55] – lunetikk | webseite:mysql:basic [2018/12/20 17:40] (current) – Discussion status changed 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 ===== | ||
- | ^ Code ^ | + | ^ Code ^ |
| 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 ' | ||
Line 24: | 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: |