· 6 years ago · Apr 17, 2019, 02:20 AM
1USE it330mc_SP19_wjk56;
2
3DROP TABLE IF EXISTS
4 `example`;
5
6CREATE TABLE `example` (
7 `exampleID` int NOT NULL AUTO_INCREMENT,
8 `firstName` varchar(45) NOT NULL,
9 `lastName` varchar(45) NOT NULL,
10 `lastUpdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
11 PRIMARY KEY (`exampleID`)
12) ENGINE=InnoDB DEFAULT CHARSET=utf8;
13
14SELECT
15 *
16FROM
17 example;
18
19UPDATE `example`
20SET firstName = 'MAROHEHCEH'
21WHERE
22 exampleID = 2;
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42USE it330mc_SP19_wjk56;
43
44SELECT
45 *
46FROM
47 example;