16 The SQL Package

commit

Function

Summary

Commits changes made to a database.

Package

sql

Signature

commit &key database => nil

Arguments

database: A database.

Values

nil

Description

Thecommit function commits changes made to the database specified by database, which is*default-database* by default.

Example

In the next example, changes records in a database, andcommit is used to make those changes permanent.

 (insert-records :into [emp]
                :attributes '(x y z)
                :values '(a b c))
 (update-records [emp]
    :attributes [dept]
    :values 50
    :where [= [dept] 40])
 (delete-records :from [emp]
    :where [> [salary] 300000])
 (commit)

See also
: rollback
with-transaction