Site Tools


webseite:mysql:basic

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
webseite:mysql:basic [2017/03/01 12:50] – external edit 127.0.0.1webseite: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  |+|  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  | |  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  | |  UPDATE Personal SET Salary=3200 WHERE Lastname = "Doe";  |  Change the salary of a person with the lastname Doe  |
Line 42: Line 42:
 \\ \\
 \\ \\
-~~DISCUSSION~~+~~DISCUSSION:closed~~
webseite/mysql/basic.1488369020.txt.gz · Last modified: 2017/03/01 12:50 by 127.0.0.1