SQL adaptation guide For SQLite 3.5.x, 3.6.x / Data manipulation |
Informix® allows a specific syntax for UPDATE statements:
UPDATE table SET ( col-list ) = ( val-list )
Or
UPDATE table SET table.* = codeph.*
UPDATE table SET * = myrecord.*
UPDATE table SET column=value [,...]