Update Data

Updates data in an existing table

Samples

<update tableName="People">
    <column name="firstname" value="Fred"/>
    <column name="lastname" value="Johnson"/>
    <column name="username" value="fjohnson"/>
    <where>id=2</where>
</update>

<update tableName="People">
    <column name="downsized" valueBoolean="true"/>
</update>

Available Attributes

tableName	Name of the table to update data in
schemaName	Name of the table schema

Available Sub-Tags

column	Data to update. See the column tag documentation for more information. [required]
where [TEXT]	Where clause for update statement

Database Compatiblity

MySQL	No Issues
PostgreSQL	No Issues
Oracle	No Issues
MS-SQL	No Issues
Sybase	No Issues
DB2	No Issues
Derby	No Issues
HSQL	No Issues
H2	No Issues
Caché	No Issues
Firebird	No Issues
MaxDB	No Issues

Automatic Rollback Support: NO