Functional Data Manipulation Language (FDML)
Prev |  | Next

# Functional Data Manipulation Language (FDML)

The functional data manipulation interface provided by CLSQL includes functions for inserting, updating and deleting records in existing database tables and executing SQL queries and statements with the results of queries returned as Lisp types. SQL statements expressed as strings may be executed with the `query` and `execute-command` functions. The `select` function, on the other hand, allows for the construction of queries in Lisp using the symbolic SQL syntax. Finally, iterative manipulation of query results is supported by `do-query`, `map-query` and an extended clause for the `loop` macro.

Prev |  | Next
TRUNCATE-DATABASE | Home | *CACHE-TABLE-QUERIES-DEFAULT*