| Database
background (3/4) |
|
|
|
|
|
|
|
|
|
|
| n | "SQL",
or “Structured Query Language”, is a syntax for |
||||||||
| specifying in an
almost English manner what is to be done |
|||||||||
| to data. Examples: |
|||||||||
| n | SELECT
* FROM Student WHERE LEFT(Last_Name,1)=’M’ |
||||||||
| n | UPDATE
Grade SET Grade.Final=’A’ FROM Grade LEFT |
||||||||
| JOIN
STUDENT ON Grade.Student_ID=Student.ID WHERE |
|||||||||
| Student.Major=’Physics’ |
|||||||||