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. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.