Short sql help

Update command syntax

2008-03-12T17:33:33Z

Update syntax introduction:

Update command alters the data contained in the table. It can change multiple columns at once and use multiple conditions.

Insert command syntax

2008-03-12T17:33:33Z

Insert syntax introduction:

Insert command is used to insert data into a table. There are three basic syntax options how to write these queries.

Select syntax

2008-03-12T17:33:33Z

Select syntax introduction:

Select command is used to acquire and return data from certain table. In this intro I will describe only the most elementary select statements and modifiers.

Select syntax is very self explanatory, but you must respect positiong of all modificators (where, limit, order by, etc). When I explain the details of using a modifier I always mention the positioning of the parameter within the query.