Applied Network Security

SQL command examples

The first example will demonstrate how to select data from a table:

SELECT <Column List> FROM<Table Name> WHERE <Search Condition>
SELECT FirstName, LastName, OrderDate
FROM Orders WHERE OrderDate > '12/20/2016'

The next example will show you how to update data in a table:

SET <Column1> = <Value1>, <Column2> = <Value2>, ...WHERE <Search Condition>
UPDATE OrdersSET FirstName = 'John', LastName = 'Who'WHERE LastName='Who'

The select query from the first example can be broken into four clauses: select, from, where, and order by. The most basic select statement only has two parts. The first part is what columns you want to return. The second part is what tables those columns come from. Remember, if you want to retrieve ...