SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS Customers ( CustomerID int NOT NULL PRIMARY KEY, Vorname varchar(255), Nachname varchar(255), Straße varchar(255), Hausnummer varchar(255), PLZ int, Ort varchar(255) ); INSERT INTO Customers (CustomerID, Vorname, Nachname, Straße, Hausnummer, PLZ, Ort) VALUES (1, "Julia", "Ströhle", "Hinterhofgasse", "13a", 7229, "Münchhausen"), (2, "Hannah", "Scharf", "Sulmtalgasse", "277", 8010, "Graz"), (3, "Eva", "Polz", "Schildkrötenweg", "1", 8675, "Kleindorf"), (4, "Günther", "Steirer", "Schulweg", "24", 8020, "Graz"), (5, "Karl-Heinz", "Müller", "Sportgasse", "10b", 8430, "Leibnitz"); SELECT * FROM Customers; CREATE TABLE IF NOT EXISTS Orders ( OrderID int NOT NULL PRIMARY KEY, Bestellmenge int, Datum Date, CustomerID int ); INSERT INTO Orders (OrderID, Bestellmenge, Datum, CustomerID) VALUES (1, 3, current_date(), 5), (2, 1, current_date(), 2), (3, 6, current_date(), 4), (4, 99, current_date(), 1); SELECT * FROM Orders; CREATE TABLE IF NOT EXISTS PaymentDetails ( CustomerID int, Bankname varchar(255), IBAN varchar(255), BIC varchar(255) ); INSERT INTO PaymentDetails (CustomerID, Bankname, IBAN, BIC) VALUES (1, "Raffeisen Bank", "AT56789065473247", "VGRTH"), (2, "Bawag PSK", "AT56789044473247", "fgs645"), (3, "Ing Diba", "AT11789065473247", "DIBAAG"), (4, "n26", "AT56785555473247", "2626262"), (5, "Raffeisen Bank", "AT06789065473247", "VGRTH"); SELECT * FROM PaymentDetails; SELECT * FROM Customers WHERE Ort = "Graz"; SELECT * FROM Orders WHERE Bestellmenge > 5; SELECT Customers.CustomerID, Customers.Vorname, Customers.Nachname, Customers.Straße, Customers.Hausnummer, Customers.PLZ, Customers.Ort, PaymentDetails.CustomerID, PaymentDetails.Bankname, PaymentDetails.IBAN, PaymentDetails.BIC FROM Customers INNER JOIN PaymentDetails ON Customers.CustomerID = PaymentDetails.CustomerID; SELECT Customers.CustomerID, Customers.Vorname, Customers.Nachname, Customers.Straße, Customers.Hausnummer, Customers.PLZ, Customers.Ort, Orders.OrderID, Orders.Bestellmenge, Orders.Datum, Orders.CustomerID FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear