A dataset consisting of the results from a SQL query
A dataset consisting of the results from a SQL query
sql_record_spec(names, types)
sql_dataset(driver_name, data_source_name, query, record_spec)
sqlite_dataset(filename, query, record_spec)
Arguments
names | Names of columns returned from the query |
types | List of |
driver_name | String containing the database type. Currently, the only supported value is 'sqlite'. |
data_source_name | String containing a connection string to connect to the database. |
query | String containing the SQL query to execute. |
record_spec | Names and types of database columns |
filename | Filename for the database |
Value
A dataset