Datenbanksysteme: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Omega (Diskussion | Beiträge) K (→CREATE TABLE: vll anschaulicher) |
Omega (Diskussion | Beiträge) (noch son bisschen Relationenalgebra) |
||
Zeile 1: | Zeile 1: | ||
* [[Datenbanksysteme:Prüfungsschwerpunkte|Prüfungsschwerpunkte]] | * [[Datenbanksysteme:Prüfungsschwerpunkte|Prüfungsschwerpunkte]] | ||
+ | |||
+ | == Relationale Datenbanken == | ||
+ | |||
+ | === Relationenalgebra === | ||
+ | |||
+ | ==== Selection ==== | ||
+ | <math>sigma Ort=Magdeburg (Kunde)</math> | ||
+ | |||
+ | ==== Projektion ==== | ||
+ | |||
+ | === SQL-Formulierung === | ||
==== CREATE TABLE ==== | ==== CREATE TABLE ==== |
Version vom 8. Februar 2006, 15:17 Uhr
Relationale Datenbanken
Relationenalgebra
Selection
Projektion
SQL-Formulierung
CREATE TABLE
CREATE TABLE tbl_name ( [ col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [ UNIQUE [KEY] | [PRIMARY] KEY] | PRIMARY KEY [index_type] (index_col_name,...) | FOREIGN KEY (index_col_name,...) [REFERENCES tbl_name [(index_col_name,...)]] ],... );
SELECT
SELECT [DISTINCT] select_expr, ... [FROM table_references [WHERE where_condition] [GROUP BY {col_name | expr | position} [ASC | DESC], ... [WITH ROLLUP]] [HAVING where_condition] [ORDER BY {col_name | expr | position} [ASC | DESC], ...]
Verschachtelung mit where_condition möglich.
WHERE [NOT] IN references
INSERT
INSERT INTO tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),...
UPDATE
UPDATE table_references SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_condition]
DELETE
DELETE FROM tbl_name [WHERE where_condition]