SQLMemTable: Embedded BDE Alternative
In-Memory SQL Database for Delphi / C++Builder



UPDATE Statement

Previous  Top  Next


Introduction

The INSERT statement is used to modify one or more existing rows in a table.

Syntax

UPDATE table_reference [Password "password_value"]
SET column_ref = update_value [,column_ref = update_value...]
[WHERE condition]

Use the UPDATE statement to modify one or more column values in one or more existing rows in a single table.
Use a table reference in the UPDATE clause to specify the table to receive the modified data.
MEMORY option specifies that in-memory table will be created.

The SET clause is a comma-separated list of update expressions for the UPDATE statement. The syntax is as follows:

SET column_ref = update_value [,column_ref = update_value...]

Use SET clause to specify columns to update data and a new values for them.

The WHERE clause specifies filtering conditions for the UPDATE statement. The syntax is as follows:

WHERE condition

Use a WHERE clause to update only records that meets specified conditions.

Here is an example:

UPDATE Members SET FirstName = 'New Name' WHERE ID >= 3


© AidAim Software SQLMemTable: In-memory Sql Database Delph