5U4304ik

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) ON UPDATE SET NULL ON DELETE CASCADE
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
26UPDATE houses 
27SET id = 10 
28WHERE id = 1;
29
30SELECT *
31FROM houses;
32SELECT *
33FROM people;