SQL & Query

SQL & Query

1. SQL stands for Structured Query Language

2. A query is something that asks a question to get a result, searches the database. Shows you only the data that fufills the required query

3. Boolean Operators: And, Or, Not

4. A Query by Example (QBE) creates queries based on common examples like certain filters, which lets you see only part of the data that is required

5. SELECT certain Field, FROM which Table, WHERE this is happening

6. CREATE TABLE tablename (column1 datatype(length), column2 datatype(length), column3 datatype(length)...);

   • CREATE TABLE Programmes (ID int(2), Title varchar(20), Genre varchar(20), Duration int(3));

7. ORDER BY FIELD, orders the field in ascending order by default

8. Wildcard '*', this means ALL used when things are unknown but some part of it is know

Bilder und Dateien der Mindmap