Structured Query Language

Syntax.
1. Keyword are Not case sensitive.
2. * = All.
3. After each command a ';' is needed to show the end.
  1. This is not needed after each line.
4. % = missing words.
Select.
1. Allows data to be selected from a Database.
  1. More than one selection can be made, all separated with a comma.
2. Needs From statement to specify which database to select from.
Distinct.
1. Removes all of the Duplicates from a Selection.
Where.
1. Allows Data to be Filtered. ie: only select records where country = 'Germany'.
And/Or.
1. And Allows Records to be selected based on two values. ie: where sex = male AND age = < 30.
2. Or allows data to be selected based on either of two values. ie: Sex = male OR Age = < 30.
Order By.
1. Allows a Database or selection to be ordered by a specific thing. ie: CustomerNames in descending order.
Insert Into.
1. Allows Data to be added to a database.
Update.
1. Allows date to be modified in a database.
2. Where statement needed to make sure all records are not modifies.
Delete.
1. Allows records to be deleted from a database.
2. Needs Where statement to make sure not all records are deleted.
From.
1. Tells it what to do the operation on.
Like.
1. Allows a pattern to be searched for.
Drop.
1. Allows an entire database to be deleted.
Join.
1. Allows all data from two data bases to be joined together, if the columns match.

Zusammenfassung der Ressource

	Erstellt von Matt Smith vor etwa 7 Jahre