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:14] – lunetikk | webseite:mysql:basic [2015/06/15 15:44] – lunetikk | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== MySQL Basics ====== | ====== MySQL Basics ====== | ||
- | ===== Code ===== | + | |
==== Data Definition Language (DDL) ==== | ==== Data Definition Language (DDL) ==== | ||
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^What it does^ | + | ^ 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~~ |