Differences

This shows you the differences between two versions of the page.

--- webseite:mysql:basic [2014/11/30 03:52] – lunetikk
+++ webseite:mysql:basic [2015/06/10 11:43] – lunetikk
@@ Line 15: / Line 15: @@
 |  UPDATE  |  updates existing data in a table  |
 |  DELETE  |  deletes all records from a table, space for the records remain  |
+===== Basics =====
+^  Code  ^  Function  ^
+|  CREATE TABLE Personal (Lastname CHAR(50) Firstname CHAR(50) Rank VARCHAR(30) Salary (INT);  |  Create table  |
+|  INSERT INTO Personal (Lastname, Firstname) VALUES ('Doe', 'John')  |  Insert in table  |
+|  UPDATE Personal SET Salary=3200 WHERE Lastname = "Doe";  |  Change the salary of a person with the lastname Doe  |
+|  DELETE FROM Personal WHERE Lastname = "Doe" AND Firstname = "John";  |  Remove John Doe  |
+|  DROP TABLE Personal;  |  Remove table  |
+|  ALTER TABLE Personal ADD Gender CHAR (1);  |  Add a new column Gender  |
+|  SELECT Lastname, Firstname FROM Personal ORDER BY Lastname;  |  Order the output by lastname  |
+|  SELECT Rank FROM Personal GROUP BY Rank;  |  Shows the ranks grouped  |
+|  SELECT COUNT(*) FROM table;  |  Counts all entries  |
+|  SELECT * FROM table WHERE field LIKE '%text%';  |  Select all columns for a field with the value "text"  |
+|  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 =====

Lunetikk's IT Wiki