SQL: Unterschied zwischen den Versionen
Aus informatikvs
(Die Seite wurde neu angelegt: „;sql-ddl: (Data Definition Language) das erstellen/ändern/löschen von datenbankstrukturen (tables, fields, views, ...) ;sql-dml: (Data Manipulation Language…“) |
|||
| Zeile 1: | Zeile 1: | ||
;sql-ddl: (Data Definition Language) das erstellen/ändern/löschen von datenbankstrukturen (tables, fields, views, ...) | ;sql-ddl: (Data Definition Language) das erstellen/ändern/löschen von datenbankstrukturen (tables, fields, views, ...) | ||
| + | <br /> | ||
;sql-dml: (Data Manipulation Language) das erstellen/ändern/löschen des inhalts (daten) der datenbankstrukturen | ;sql-dml: (Data Manipulation Language) das erstellen/ändern/löschen des inhalts (daten) der datenbankstrukturen | ||
| + | <br /> | ||
;sql-dcl: (Data Control Language) Transaktionskontrolle und Zugriffsberechtigungen | ;sql-dcl: (Data Control Language) Transaktionskontrolle und Zugriffsberechtigungen | ||
| + | <br /> | ||
;sql-injection | ;sql-injection | ||
| + | <br /> | ||
;transaktionen | ;transaktionen | ||
| + | <br /> | ||
;attribut | ;attribut | ||
| + | <br /> | ||
;index | ;index | ||
| + | <br /> | ||
;commands: such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" | ;commands: such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" | ||
| + | <br /> | ||
;tables: are uniquely identified by their names and are comprised of columns and rows. | ;tables: are uniquely identified by their names and are comprised of columns and rows. | ||
| + | <br /> | ||
;columns: contain the column name, data type, and any other attributes for the column. | ;columns: contain the column name, data type, and any other attributes for the column. | ||
| + | <br /> | ||
;rows: contain the records or data for the columns. | ;rows: contain the records or data for the columns. | ||
| + | <br /> | ||
;the where-clause: optional specifies which data values or rows will be returned (criterias: =, <>, <, >, >=, <=, like) | ;the where-clause: optional specifies which data values or rows will be returned (criterias: =, <>, <, >, >=, <=, like) | ||
| + | <br /> | ||
;tuple: is a collection of one or more attributes or rows present in a table | ;tuple: is a collection of one or more attributes or rows present in a table | ||
| + | <br /> | ||
;constraints: are uses to limit the values of variables NOT NULL; UNIQUE; PRIMARY KEY; FOREIGN KEY; CHECK; DEFAULT | ;constraints: are uses to limit the values of variables NOT NULL; UNIQUE; PRIMARY KEY; FOREIGN KEY; CHECK; DEFAULT | ||
| + | <br /> | ||
;subquery | ;subquery | ||
| + | <br /> | ||
;aggregat functions: avg(); count(); count(dinstinct field); max(); ... | ;aggregat functions: avg(); count(); count(dinstinct field); max(); ... | ||
| + | <br /> | ||
;scalar functions: ucase(), lcase(), mid(), len(), left(), right(), round(), mod(), now() | ;scalar functions: ucase(), lcase(), mid(), len(), left(), right(), round(), mod(), now() | ||
| + | <br /> | ||
;olap cube() rollup() | ;olap cube() rollup() | ||
Version vom 1. Mai 2017, 06:04 Uhr
- sql-ddl
- (Data Definition Language) das erstellen/ändern/löschen von datenbankstrukturen (tables, fields, views, ...)
- sql-dml
- (Data Manipulation Language) das erstellen/ändern/löschen des inhalts (daten) der datenbankstrukturen
- sql-dcl
- (Data Control Language) Transaktionskontrolle und Zugriffsberechtigungen
- sql-injection
- transaktionen
- attribut
- index
- commands
- such as "Select", "Insert", "Update", "Delete", "Create", and "Drop"
- tables
- are uniquely identified by their names and are comprised of columns and rows.
- columns
- contain the column name, data type, and any other attributes for the column.
- rows
- contain the records or data for the columns.
- the where-clause
- optional specifies which data values or rows will be returned (criterias: =, <>, <, >, >=, <=, like)
- tuple
- is a collection of one or more attributes or rows present in a table
- constraints
- are uses to limit the values of variables NOT NULL; UNIQUE; PRIMARY KEY; FOREIGN KEY; CHECK; DEFAULT
- subquery
- aggregat functions
- avg(); count(); count(dinstinct field); max(); ...
- scalar functions
- ucase(), lcase(), mid(), len(), left(), right(), round(), mod(), now()
- olap cube() rollup()
