sql_list: Convert R vector to Single SQL Query Clause String.
In ds4ci/ds4ciMisc: Miscellaneous Functions for DS4CI Projects
Description
Usage
Arguments
Details
Value
Examples
Description
sql_list() Returns a character string which can be pasted into
a SQL query without throwing an error.
Usage
1
sql_list(MyVector)
Arguments
MyVector
A single dimension vector. Will be cast to character with
as.character()
Details
Usually used in SQL WHERE clause as
paste("... WHERE <exp> IN", sql_list(vector)).
Value
A single character sting of elements in the input vector surrounded
by parens. Each element is enclosed in single quotes and seperated by
commas.
Examples
1
2
ds4ci/ds4ciMisc documentation built on May 15, 2019, 2:56 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details Value Examples
Description
sql_list() Returns a character string which can be pasted into
a SQL query without throwing an error.
Usage
1 | sql_list(MyVector)
|
Arguments
MyVector |
A single dimension vector. Will be cast to character with
|
Details
Usually used in SQL WHERE clause as
paste("... WHERE <exp> IN", sql_list(vector)).
Value
A single character sting of elements in the input vector surrounded by parens. Each element is enclosed in single quotes and seperated by commas.
Examples
1 2 |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.