Function

Summary

Queries a database and returns a list of values.

Package

sql

Signature

query sql-exp &key database => result-list, field-names

Arguments

sql-exp

An SQL query statement to be performed.

database

A database.

Values

result-list

A list of values.

field-names

A list of strings.

Description

The function query is the basic SQL query function. It queries the database specified by database with an SQL query statement given by query-expression .

The argument database defaults to *default-database* .

result-list is a list of values as per select, and field-names is a list of field names selected in sql-exp .

See also

do-query
execute-command
loop
map-query
select