blob: 74d47e43c1159bedeb48353276a08eddab68a3e3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
alter table Klant add column Woonplaats varchar(45) not null;
alter table `Order` add column Leverdatum date not null;
alter table Product add column Voorraad int not null;
update Klant set Woonplaats = "'s-Hertogenbosch" where ID = 1;
update Klant set Woonplaats = "Nijmegen" where ID = 2;
update Klant set Woonplaats = "Tilburg" where ID = 3;
update `Order` set Leverdatum = '2022-10-02' where ID = 1;
update `Order` set Leverdatum = '2014-03-13' where ID = 2;
update `Order` set Leverdatum = '2019-01-01' where ID = 3;
update `Order` set Leverdatum = '2023-07-28' where ID = 4;
update `Order` set Leverdatum = '2018-02-23' where ID = 5;
update Product set Voorraad = 15 where ID = 1;
update Product set Voorraad = 7 where ID = 2;
update Product set Voorraad = 23 where ID = 3;
update Product set Voorraad = 14 where ID = 4;
update Product set Voorraad = 30 where ID = 5;
|