update-records

update-records Function

Summary

Changes the values of fields in a table.

Package

sql

Signature

update-records table &key attributes values av-pairs where database

Arguments

`table`⇩	A database table.
`attributes`⇩	A set of columns.
`values`⇩	A set of values.
`av-pairs`⇩	An association list alternative to `attributes` and `values`.
`where`⇩	A condition.
`database`⇩	A database.

Description

The function update-records changes the values of existing fields in table in database with columns specified by attributes and values (or av-pairs) where the condition where is true.