You are wrong... since the SQL query you wish to create is itself a string.
Of course, you cannot send a SQL fragment such as you used as an example, so be
sure to form a complete, syntactically correct SQL statement before giving it
to your database query function.
Oh, and if you need more ass
is this what you want"
> x <- c(1, 2, 3, 4, 5)
> paste0("where ASSETT in (", paste(x, collapse = ','), ")")
[1] "where ASSETT in (1,2,3,4,5)"
On Fri, May 17, 2013 at 11:46 AM, Manta wrote:
> Hi all,
>
> I have a vector of numbers, and to be able to pass it to RMySQL and use the
> IN clause I
Hi all,
I have a vector of numbers, and to be able to pass it to RMySQL and use the
IN clause I need to have this vector to be a single list numeric and comma
separated.
I saw the post below but it is about strings, which I do not need (I cannot
pass strings in this SQL query, I need something li
3 matches
Mail list logo
