Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
Copy Format Clear
CREATE TABLE bolumler ( bolum_id INT PRIMARY KEY, bolum_adi VARCHAR(100) ); CREATE TABLE ogrenciler ( ogrenci_id INT PRIMARY KEY, ad VARCHAR(50), soyad VARCHAR(50), dogum_yili INT, bolum_id INT, FOREIGN KEY (bolum_id) REFERENCES bolumler(bolum_id) ); CREATE TABLE dersler ( ders_id INT PRIMARY KEY, ders_adi VARCHAR(100), kredi INT ); CREATE TABLE notlar ( ogrenci_id INT, ders_id INT, notu INT, PRIMARY KEY (ogrenci_id, ders_id), FOREIGN KEY (ogrenci_id) REFERENCES ogrenciler(ogrenci_id), FOREIGN KEY (ders_id) REFERENCES dersler(ders_id) );

Stuck with a problem? Got Error? Ask AI support!

Copy Clear