GSAK (Geocaching Swiss Army Knife)
 

Contents - Index


SQL - Update


Allows you to update existing data.Allows setting a particular field in a SQL table to a specified value. Multiple fields can be set this way with one command by specifying several fields and their values in the updatelist.

Syntax:

  UPDATE tablename SET updatelist [WHERE condition]
 
Updatelist

field1=value1[,fieldN=valueN]

condition see WHERE  for the optional condition

Copyright 2004-2008 CWE Computer Services  
Privacy Policy Contact