Short for 'Structured Query Language'.
SQL was created for use with an SQL database. It consists of a set of commands that can carry out the following tasks
- Search records
- Update records
- Insert records
- Delete records
- Find related records
The table below shows the SQL statements you need to undestand
|SELECT||This retrieves a record. Other commands can then be carried out on that record without affecting the whole database.|
|FROM||The identifies the table where the data comes from|
|WHERE||This sets out some condition with which to choose only certain records|
|AND||The allows multiple conditions to be set all of which must be true|
|OR||This allows multiple conditions to be set, any of which needs to be true|
|LIKE||This allows data to be selected that are similar to the criteria set with like|
These will de discussed over the next few pages.
Challenge see if you can find out one extra fact on this topic that we haven't already told you
Click on this link: What is SQL?