Inventurliste

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
=Inventurliste=

==Tabellen und Daten==

===Tabellen===

<popup name="Tabellenstruktur">
<code id="5c51e3702e982">
DROP TABLE IF EXISTS Inhalt;
CREATE TABLE Inhalt(
              Nummer varchar (255),
              Name varchar (255),
              Gewicht varchar (255),
              Tag varchar (5),
              Monat varchar (255),
              Jahr varchar (7),
              Anzahl varchar (5)
);
</code>
</popup>

===Datensätze===

<popup name="Datensätze">
<code id="5c51f159ee953">

INSERT INTO Inhalt VALUES ('0001', 'Tafelsalz', '500g', '-', '-', '-', '1');
INSERT INTO Inhalt VALUES ('0002', 'Reis', '125g', '09', '12', '2020', '5');
INSERT INTO Inhalt VALUES ('0003', 'Backmischng Mandarine-Schmand', '-', '28', '09', '2019', '1');
INSERT INTO Inhalt VALUES ('0004', 'Pfirsiche', '820g', '15', '12', '2021', '1');
INSERT INTO Inhalt VALUES ('0005', 'Kokusnussmilch', '400ml', '31', '12', '2020', '1');
INSERT INTO Inhalt VALUES ('0006', 'Letscho', '680g', '24', '09', '2019', '1');
INSERT INTO Inhalt VALUES ('0007', 'Tomatensaft', '500ml', '02', '04', '2019', '1');
INSERT INTO Inhalt VALUES ('0008', 'Honig', '-', '-', '-', '-', '1');
INSERT INTO Inhalt VALUES ('0009', 'Kichererbsen', '400g', '31', '12', '2019', '2');
INSERT INTO Inhalt VALUES ('0010', 'Mango', '420g', '31', '12', '2020', '1');
INSERT INTO Inhalt VALUES ('0011', 'Schmelzkäse', '200g', '10', '06', '2019', '2');
INSERT INTO Inhalt VALUES ('0012', 'Holunderblütengelee', '-', '-', '-', '-', '1');
INSERT INTO Inhalt VALUES ('0013', 'Kidneybohnen', '420g', '27', '05', '2020', '1');
INSERT INTO Inhalt VALUES ('0014', 'Schwarzwurzeln', '540g', '31', '01', '22', '2');
INSERT INTO Inhalt VALUES ('0015', 'Olivenöl', '250ml', '01', '10', '2020', '1');
INSERT INTO Inhalt VALUES ('0016', 'Cornichons', '330g', '31', '12', '2021', '1');
INSERT INTO Inhalt VALUES ('0017', 'Soßenbinder hell', '250g', '01', '10', '2020', '1');
INSERT INTO Inhalt VALUES ('0018', 'trockene Bohnen', '-', '-', '-', '-', '2');
INSERT INTO Inhalt VALUES ('0019', 'Bruschetta', '-', '-', '-', '-', '1');
INSERT INTO Inhalt VALUES ('0020', 'Datteln', '250g', '25', '08', '2019', '1');

</code>
</popup>


==Mögliche Abfragen==

Name, Gewicht, Tag, Monat, Jahr, Anzahl



==Abfrage==

<run id="5c52134039016">
SELECT  FROM Inhalt
</run>
Inventurliste

Suche
