Veritabanı adı: Dunya
Tablo Adı: sehirler
sutun isimleri resimde mevcut

1. Dunya adında DATABASE oluştur.
CREATE DATABASE Dunya

2. sehirler adında table oluşturuyoruz
CREATE TABLE sehirler(ID INT(3)NOT NULL PRIMARY KEY AUTO_INCREMENT,Name char(35)CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  ,CountryCode CHAR(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci , Discrict CHAR(20)CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci , Population INT(11) NOT NULL )

3. 10 TANE VERİ EKLİYORUZ.
INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Kabul","AFG","Kabol",1780000)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Qandahar","AFG","Qandahar",237500)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Herat","AFG","Herat",186800)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Mazar-e-Sharif","AFG","Balkh",127800)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Amsterdam","NLD","Noord-Holland",731200)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Rotterdam","NLD","Zuid-Holland",593321)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Haag","NLD","Zuid-Holland",440900)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Utrecht","NLD","Utrech",234323)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Eindhoven","NLD","Noord-Brabant",201843)

INSERT INTO sehirler(Name,CountryCode,Discrict,Population)
VALUES("Tilburg","NLD","Noord-Brabant",193238)



4. IDSI 1 OLAN KAYITI GETİR.
SELECT * FROM `sehirler` WHERE ID = 1

5. POPULATİON 593321 GETİR.
SELECT * FROM `sehirler` WHERE Population=593321

6.ÜLKE KODU AFG OLANLARI LİSTELE
SELECT * FROM `sehirler` WHERE CountryCode="AFG"

7. ID = 1 OLANI SİL
DELETE FROM sehirler WHERE ID = 1

8. ID = 2 OLAN KAYIT GÜNCELLE
UPDATE sehirler SET Name ="Groningen",CountryCode="NLD",Discrict="Groningen",Population=172701

9. sehirler TABLOSUNU SİL
DROP TABLE sehirler

10. Dunya DATABASE SİL
DROP DATABASE dunya