Displaying 1 result from an estimated 1 matches for "read_id".
Did you mean:
head_id
2010 Mar 08
2
using sprintf to pass a variable to a RMySQL query
...how
do I iterate for i 1-72? Escape characters,?
thanks in advance
i<-1
sqlcmd_ScaffLen<-sprintf('SELECT scaffold.length
FROM scaffold,scaffold2contig,contig2read
WHERE scaffold.scaffold_id=scaffold2contig.scaffold_id AND
scaffold2contig.contig_id=contig2read.contig_id AND contig2read.read_id LIKE
'%MG%s%' ,i)
========= Here is my vague error message
Error: unexpected input in: