Update command syntax

Wednesday, 12 March 2008 18:33

Update syntax introduction:

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

Read more: Update command syntax

Insert command syntax

Wednesday, 12 March 2008 18:33

Insert syntax introduction: 

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

Read more: Insert command syntax

Select syntax

Wednesday, 12 March 2008 18:33

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.

Read more: Select syntax