Description Usage Arguments Value Examples
monetdb_queryinfo(...)
is used to get the expected result set structure (# rows, # columns, column names, column types etc.) without actually running the query.
1 | monetdb_queryinfo(conn, query)
|
conn |
Database name |
query |
SQL SELECT query to get information about |
Environment with various entries, e.g.
cols
– number of columns
rows
– number of rows
types
– vector of column type from database (e.g. "VARCHAR" or "INT")
names
– vector of column names
tables
– vector of table names
1 2 3 4 | ## Not run:
monetdb_queryinfo("demo","SELECT 1")
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.