SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Person ( PersonID INTEGER, Name VARCHAR(32), Jahre INTEGER, EMail VARCHAR(64), PRIMARY KEY (PersonID) ); INSERT INTO Person VALUES ( '10000', 'Schneider', '5', 'Köln' ); INSERT INTO Person VALUES ( '10001', 'Müller', '30', 'Köln' ); INSERT INTO Person VALUES ( '10002', 'Schmidt', '36', 'Köln' ); INSERT INTO Person VALUES ( '10003', 'Stratmann', '36', 'Köln' ); CREATE TABLE Buch ( ISBN VARCHAR(13), Autor INTEGER, Titel VARCHAR(64), Seiten INTEGER, PRIMARY KEY (ISBN) ); CREATE TABLE Review ( PersonID INTEGER, ISBN VARCHAR(13), Inhalt TEXT, Sterne INTEGER, PRIMARY KEY (PersonID, ISBN) ); SELECT * FROM Person WHERE Jahre <> 30; SELECT DISTINCT Name FROM Person WHERE Name NOT LIKE '_t%';