| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Finally, you can manage your Google Docs, uploads, and email attachments (plus Dropbox and Slack files) in one convenient place. Claim a free account, and in less than 2 minutes, Dokkio (from the makers of PBworks) can automatically organize your content for you.

View
 

SQL_GrundlegendeStruktur

Page history last edited by GSGInformatik 5 months ago

Abfragen

SELECT <Attribut(e)>

FROM <Tabellenname(n)>

WHERE <Bedingung(en)>;

 

Beispiel: SELECT Artikel, Preis FROM Produkt WHERE Hersteller = 'Dr. Oetker';

 

Ändern

UPDATE <Tabellenname>

SET <Attribut> = <Wert>

WHERE <Bedingung(en)>

 

Einfügen

INSERT INTO <Tabellenname> ('Attribut1', 'Attribut2', ...)

VALUES ('Wert1', Wert2', 'Wert3',...);

 

Beispiel: INSERT INTO Produkt ('Barcode', 'Artikel', 'Hersteller', 'Beschreibung', 'Preis') VALUES ('4253565', 'Ravioli', 'Knorr', 'Dosenravioli', 2.65);

 

Löschen

DELETE FROM <Tabellenname>

WHERE <Bedingung(en)>;

Comments (0)

You don't have permission to comment on this page.