Kod SQL ile Basit Kod Örnekleri - Lojistik Tim

CREATE TABLE Kisiler (ID INT PRIMARY KEY AUTO_INCREMENT,Isim VARCHAR(50),Yas INT);

INSERT INTO Kisiler (Isim, Yas) VALUES ('Ali', 30);

UPDATE Kisiler SET Yas = 31 WHERE Isim = 'Ali';

DELETE FROM Kisiler WHERE Isim = 'Ali';

SELECT * FROM Kisiler;

SELECT Isim, Yas FROM Kisiler;

SELECT * FROM Kisiler WHERE Yas > 25;

SELECT * FROM Kisiler ORDER BY Yas DESC;

SELECT Yas, COUNT(*) as KisiSayisi FROM Kisiler GROUP BY Yas;

SELECT Kisiler.Isim, Siparisler.SiparisTarihiFROM KisilerJOIN Siparisler ON Kisiler.ID = Siparisler.KisiID;

SELECT * FROM Kisiler WHERE Yas > (SELECT AVG(Yas) FROM Kisiler);

SELECT DISTINCT Yas FROM Kisiler;

UPDATE Kisiler SET Yas = Yas + 1;

SELECT COUNT(*) as ToplamKisi, MAX(Yas) as EnYuksekYas, MIN(Yas) as EnDusukYas FROM Kisiler;

INSERT INTO Kisiler (Isim, Yas) VALUES ('Ayşe', 22), ('Mehmet', 35), ('Fatma', 29);

SELECT SUM(Yas) as ToplamYas FROM Kisiler;

SELECT CONCAT(Isim, ' - ', Yas) as Bilgi FROM Kisiler;

SELECT * FROM Kisiler WHERE Isim LIKE 'A%';

SELECT * FROM Kisiler WHERE Yas IS NULL;

DELETE FROM Kisiler WHERE Yas < 18;

SELECT Isim,CASEWHEN Yas < 18 THEN 'Genç'WHEN Yas BETWEEN 18 AND 65 THEN 'Yetişkin'ELSE 'Yaşlı'END as YasGrubuFROM Kisiler;

SELECT Yas, GROUP_CONCAT(Isim) as Isimler FROM Kisiler GROUP BY Yas;

SELECT Yas, COUNT() as KisiSayisiFROM KisilerGROUP BY YasHAVING COUNT() > 1;

CREATE VIEW YasliKisiler ASSELECT * FROM Kisiler WHERE Yas > 60;

DROP TABLE Kisiler;DROP DATABASE VeritabaniAdi;