-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhomework8.sql
69 lines (66 loc) · 6.06 KB
/
homework8.sql
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
-- 1. test veritabanınızda employee isimli sütun bilgileri id(INTEGER), name VARCHAR(50), birthday DATE, email VARCHAR(100) olan bir tablo oluşturalım.
CREATE TABLE employee(
id SERIAL PRIMARY KEY,
name VARCHAR(50),
birthday DATE,
email VARCHAR(100)
);
-- 2. Oluşturduğumuz employee tablosuna 'Mockaroo' servisini kullanarak 50 adet veri ekleyelim.
insert into employee (name, birthday, email) values ('Krystle Cuddehy', '1904-12-26', '[email protected]');
insert into employee (name, birthday, email) values ('Lilith Inglish', '1993-10-08', '[email protected]');
insert into employee (name, birthday, email) values ('Thayne Morales', '1960-11-08', '[email protected]');
insert into employee (name, birthday, email) values ('Ambrosi Leahair', '1948-02-25', '[email protected]');
insert into employee (name, birthday, email) values ('Alaric Klug', '1925-07-18', '[email protected]');
insert into employee (name, birthday, email) values ('Ambrosi Fortnum', '2021-12-12', '[email protected]');
insert into employee (name, birthday, email) values ('Nahum Todman', '1985-03-09', '[email protected]');
insert into employee (name, birthday, email) values ('Dianne Budleigh', '1911-06-24', '[email protected]');
insert into employee (name, birthday, email) values ('Midge Skedge', '1903-07-03', '[email protected]');
insert into employee (name, birthday, email) values ('Lindsy Gillet', '1936-03-13', '[email protected]');
insert into employee (name, birthday, email) values ('Joly Hanalan', '1904-11-27', '[email protected]');
insert into employee (name, birthday, email) values ('Inesita Lelievre', '1906-08-12', '[email protected]');
insert into employee (name, birthday, email) values ('Aggie Klugel', '1943-05-04', '[email protected]');
insert into employee (name, birthday, email) values ('Velma Horche', '2007-04-17', '[email protected]');
insert into employee (name, birthday, email) values ('Dorise Kestin', '1908-08-20', '[email protected]');
insert into employee (name, birthday, email) values ('Zachariah Mossom', '1960-04-30', '[email protected]');
insert into employee (name, birthday, email) values ('Mei Fake', '1969-03-18', '[email protected]');
insert into employee (name, birthday, email) values ('Lauritz Ulrik', '1963-08-08', '[email protected]');
insert into employee (name, birthday, email) values ('Libby Whyke', '1968-06-21', '[email protected]');
insert into employee (name, birthday, email) values ('Wylma Lucks', '1908-10-09', '[email protected]');
insert into employee (name, birthday, email) values ('Lavinie Mankor', '1965-08-19', '[email protected]');
insert into employee (name, birthday, email) values ('Gavin Koppelmann', '2000-09-29', '[email protected]');
insert into employee (name, birthday, email) values ('Pasquale Curnick', '1912-06-24', '[email protected]');
insert into employee (name, birthday, email) values ('Hammad Nolleth', '1949-07-25', '[email protected]');
insert into employee (name, birthday, email) values ('Lavinie Mole', '1900-09-05', '[email protected]');
insert into employee (name, birthday, email) values ('Sherie Manuaud', '1911-06-10', '[email protected]');
insert into employee (name, birthday, email) values ('Holden Allaway', '1990-01-24', '[email protected]');
insert into employee (name, birthday, email) values ('Delaney Newlands', '1988-11-29', '[email protected]');
insert into employee (name, birthday, email) values ('Donielle Frederick', '1900-10-16', '[email protected]');
insert into employee (name, birthday, email) values ('Chantalle Ancliff', '2017-12-19', '[email protected]');
insert into employee (name, birthday, email) values ('Darryl Jonczyk', '1969-04-12', '[email protected]');
insert into employee (name, birthday, email) values ('Sanford Heibel', '1904-11-25', '[email protected]');
insert into employee (name, birthday, email) values ('Avery Bramsom', '1950-11-19', '[email protected]');
insert into employee (name, birthday, email) values ('Guglielmo Colcutt', '1940-11-15', '[email protected]');
insert into employee (name, birthday, email) values ('Woodie Dwire', '1980-09-23', '[email protected]');
insert into employee (name, birthday, email) values ('Cathryn Bordis', '2001-08-11', '[email protected]');
insert into employee (name, birthday, email) values ('Nedi Ledingham', '1918-04-02', '[email protected]');
insert into employee (name, birthday, email) values ('Royal Lisciandri', '1902-10-26', '[email protected]');
insert into employee (name, birthday, email) values ('Chaddie Veysey', '1929-11-26', '[email protected]');
insert into employee (name, birthday, email) values ('Christabel Tandy', '1946-12-03', '[email protected]');
insert into employee (name, birthday, email) values ('Janeen Adame', '1906-10-23', '[email protected]');
insert into employee (name, birthday, email) values ('Shepperd Bernardoux', '1997-09-30', '[email protected]');
insert into employee (name, birthday, email) values ('Farleigh Tidbold', '1931-03-28', '[email protected]');
insert into employee (name, birthday, email) values ('Thayne Flisher', '2010-10-02', '[email protected]');
insert into employee (name, birthday, email) values ('Ardyce Joblin', '2001-12-18', '[email protected]');
insert into employee (name, birthday, email) values ('Twyla Ambrogi', '1933-10-17', '[email protected]');
insert into employee (name, birthday, email) values ('Horatia Rossey', '1944-08-20', '[email protected]');
insert into employee (name, birthday, email) values ('Cherri Bruckshaw', '1989-12-19', '[email protected]');
insert into employee (name, birthday, email) values ('Marion Bunnell', '1954-12-21', '[email protected]');
insert into employee (name, birthday, email) values ('Sigvard Yakushkin', '1934-05-07', '[email protected]');
-- 3. Sütunların her birine göre diğer sütunları güncelleyecek 5 adet UPDATE işlemi yapalım.
UPDATE emloyee
SET name = 'Umut'
email = '[email protected]'
WHERE id = 2;
-- 4. Sütunların her birine göre ilgili satırı silecek 5 adet DELETE işlemi yapalım.
DELETE FROM employee
WHERE id = 2;