Phone_SQL/Update_statements.sql at main · lbeltran5/Phone_SQL · GitHub

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
32
33
34
35
UPDATE brand
SET brand_name = 'Samsung'
WHERE brand_id = 1;

UPDATE country
SET country_name = 'Korea'
WHERE country_id = 1;

UPDATE operatingsystem
SET os_name = 'Android'
WHERE os_id = 1;

UPDATE phone
SET phone_model = 'Galaxy S21'
WHERE phone_id = 1;

UPDATE phone
SET price = 899.99
WHERE phone_id = 1;

UPDATE feature
SET feature_name = 'Wireless Charging'
WHERE feature_id = 2;

UPDATE camera
SET megapixels = 64.0
WHERE camera_id = 1;

UPDATE display
SET size = 6.7
WHERE display_id = 1;

UPDATE battery
SET capacity = 4000
WHERE battery_id = 1;