1."world"adında veritabani oluşturuyoruz
CREATE DATABASE world

2."city" adında tablo oluşturuyoruz
CREATE TABLE city(ID INT(11)PRIMARY KEY AUTO_INCREMENT,Name char(35) CHARACTER SET utf8 COLLATE utf8_turkish_ci ,CountryCode char(3),District char(20),Population INT(11)) 

3.notlar tablosuna veri ekliyoruz.

INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Kabul","AFG","Kabol",1780000)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Qandhar","AFG","Qandahar",237500)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Herat","AFG","Herat",186800)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Mazar-e-Sharif","AFG","Bakh",127800)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Amsterdam","NLD","Noord-Holland",731200)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Rotterdam","NLD","Zuid-Holland",593321)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Haag","NLD","Zuid-Holland",440900)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Utrecht","NLD","Utrecht",234323)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Eindhoven","NLD","Noord-Brabant",201843)
INSERT INTO city(Name,CountryCode,District,Population)
VALUES("Tilburg","NLD","Noord-Brabant",193238)

4.ID=1 olan kaydı listele

SELECT * FROM city WHERE ID=1

5.Population = 237500 olan kaydı listele

SELECT * FROM city WHERE Population =237500

6. Name = Kabul  olan kaydı listele
SELECT * FROM city WHERE Name ="Kabul" 

7. ID=1 OLAN KAYDI SİL
DELETE FROM city WHERE ID=1

8. ID = 2 OLAN KAYDI gücelleyelim.
UPDATE city SET Name="Emir Pek",CountryCode =11,District=60,Population=70 WHERE ID = 2

9.city Tablosunu Silme
DROP TABEL city

10.world veritabanını siliniz
DROP DATABASE world