KtJQqjuv

1DROP DATABASE IF EXISTS demo;
2CREATE DATABASE demo;
3USE demo;
4
5CREATE TABLE houses (
6id INT AUTO_INCREMENT PRIMARY KEY,
7address VARCHAR(30) NOT NULL,
8last_words TEXT);
9
10CREATE TABLE people (
11	id INT AUTO_INCREMENT PRIMARY KEY,
12	full_name VARCHAR(30) NOT NULL,
13	age INT,
14	house_id INT,
15	CONSTRAINT FOREIGN KEY (house_id) REFERENCES houses(id)
16);
17
18INSERT INTO houses (address, last_words)
19VALUES ('Godech', 'Help.'),
20       ('Stonehenge', 'Avagadabra');
21       
22INSERT INTO people (full_name, age, house_id)
23VALUES ('Stamat', 30, 1),
24       ('Kircho', 2, 2);
25       
26       
27BEGIN;
28
29UPDATE people
30SET full_name = 'Guitar'
31WHERE id = 2; 
32
33
34UPDATE people
35SET full_names = 'Piano'
36WHERE id = 1; 
37
38COMMIT;
39       
40SELECT *
41FROM people;
42
43CREATE TABLE temp_table(
44	temp_number INT
45);
46
47INSERT INTO temp_table(temp_number) 
48VALUES((SELECT COUNT(ID) FROM people));
49
50SELECT *
51FROM temp_table;