Tabelleneditor: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
FBO (Diskussion | Beiträge) Keine Bearbeitungszusammenfassung |
FBO (Diskussion | Beiträge) |
||
| Zeile 200: | Zeile 200: | ||
====Tabelle abfragen (DQL)==== | ====Tabelle abfragen (DQL)==== | ||
* '''Select:' SELECT ''field'' FROM ''table'' (WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'') | * '''Select:''' SELECT ''field'' FROM ''table'' (WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'') | ||
* '''Join:''' SELECT ''field'' FROM ''table1'' JOIN ''table2'' ON ''table2.field ''='' table1.field'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' | * '''Join:''' SELECT ''field'' FROM ''table1'' JOIN ''table2'' ON ''table2.field ''='' table1.field'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' | ||
* '''Union:''' SELECT ''field'' FROM ''table'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' UNION SELECT ''field'' FROM ''table'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' | * '''Union:''' SELECT ''field'' FROM ''table'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' UNION SELECT ''field'' FROM ''table'' WHERE ''parameter'' GROUP BY ''field'' ORDER BY ''field'' | ||
====Daten bearbeiten (DML)==== | ====Daten bearbeiten (DML)==== | ||