Hello, 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? I am using RMYQL Thanks! jorgusch -- View this message in context: http://www.nabble.com/Using-a-variable-for-mysql-database-Query-tp24166250p24166250.html Sent from the R help mailing list archive at Nabble.com.
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