Created
May 19, 2020 14:09
-
-
Save nafidurmus/960b92e6535c38032afa8492f7155b8a to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
BEGIN TRANSACTION; | |
CREATE TABLE musteri(musteri_no int PRIMARY KEY, | |
ad text, | |
yas int, | |
cinsiyet char, | |
gelir money, | |
meslek char, | |
sehir char); | |
INSERT INTO musteri VALUES(1,'nafi', 24, 'erkek', 1000, 'bilgisayar mühendisi', 'antalya'); | |
INSERT INTO musteri VALUES(2,'senanur', 24, 'kadın', 3000, 'akrostiş yazarı', 'tekirdağ'); | |
INSERT INTO musteri VALUES(3,'sefa', 25, 'erkek', 5000, 'bilgisayar mühendisi', 'niğde'); | |
INSERT INTO musteri VALUES(4,'bartu', 24, 'erkek', 10000, 'yazılım geliştirici', 'eskişehir'); | |
INSERT INTO musteri VALUES(5,'ayşegül', 20, 'kadın', 2500, "avukat", 'antalya' ); | |
insert into musteri values(6, 'irem', 29, 'kadın', 4500, 'mimar', 'istanbul'); | |
insert into musteri values(7, 'erim', 23, 'erkek', 3500, 'test mühendisi', 'izmir'); | |
insert into musteri values(8, 'kılın', 22, 'erkek', 1250, 'müdür', 'aydın'); | |
insert into musteri values(9, 'gürhan', 24, 'erkek', 3200, 'yazılım geliştirici', 'izmir'); | |
insert into musteri values(10, 'buse', 27, 'kadın', 5500, 'öğretmen', 'istanbul'); | |
COMMIT; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment