1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
| create database week3lab;
use week3lab;
show tables ;
create table q1(
id INT PRIMARY KEY ,
message VARCHAR(144)
);
ALTER TABLE q1
ADD attime TIME;
drop table q1;
create table item(
itemid INT PRIMARY KEY,
itemname VARCHAR(25) not null UNIQUE ,
itemprice double not null
);
create table stocklist(
itemid INT,
shoplocation VARCHAR(40),
count INT,
primary key (itemid,shoplocation),
FOREIGN KEY (itemid) references item(itemid) on UPDATE cascade on delete cascade
);
INSERT INTO item(itemid, itemname, itemprice)
VALUES (1,'Macbook pro 2019',3000.00),
(2,'iMac 2020', 4422.53);
select * from item;
select * from stocklist;
update item
SET itemprice = itemprice * 1.1 where itemname = 'iMac 2020';
select * from item;
|