hBRJ0DbZ

1/* Demonstration of MySQL Data Definition Language (DDL) */
2CREATE SCHEMA IF NOT EXISTS demonstration; 
3USE demonstration;
4
5CREATE TABLE User ( 
6userName VARCHAR(48) NOT NULL, 
7pwd CHAR(128) NOT NULL, 
8salt VARCHAR(32), 
9PRIMARY KEY (userName) 
10); 
11
12INSERT INTO User (userName, pwd)
13VALUES ('viktos08', 'rotkiv');
14
15INSERT INTO User (userName, pwd)
16VALUES ('emelij11', 'nemeli');
17
18/* Demonstration of MySQL Data Manipulation Language (DML) */
19
20SELECT * 
21FROM User
22WHERE userName = 'viktos08';
23
24UPDATE User
25SET pwd='hemmeligPassord'
26WHERE userName='emelij11';