Function

Summary

Commits changes made to a database.

Package

sql

Signature

commit &key database => nil

Arguments

database

A database.

Values

nil

Description

The commit 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, and commit 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