[R] Using a variable for mysql/database Query

[jorgusch]

Hello, 

Thanks! Join is not possible, as the database is simply way to large. When
we exactly now, what we are looking for maybe, but not yet…

By now, I figured the paste command - not familiar with R…, however, it only
seems to work for one - the last - entry I am using. Unfortunately, the help
section for the command help is short.

Are there ways to paste several variables into one query? The table we are
looking at also changes so, it would be quite handy to do it once in a line
on top of it.

Thanks!
 jorgusch






Dieter Menne wrote:
> 
> jorgusch <hackl.schorsch <at> web.de> writes:
> 
>> Collecting data I need to check in a mysql server. As the data are
>> dependent
>> on each other I have to filter first.
>> 
>> However, I have now the problem that I find a value and would like to
>> insert
>> it into a data query for the "real select" command. Obviously, typing 'x'
>> does not help as the database does not now this entry. Anyway to make it
>> work?
> 
> The usual way to handle these case is to construct an SQL command using
> the retrieved value by paste. 
> 
> More generally, your requirements smell like being a good use of an SQL
> join.
> 
> Dieter
> 
> 

-- 
View this message in context: http://www.nabble.com/Using-a-variable-for-mysql-database-Query-tp24166250p24183823.html
Sent from the R help mailing list archive at Nabble.com.