in reply to Re: s/Perl/SQL/ ?
in thread s/Perl/SQL/ ?
This bit of code (update: shown above) looks very interesting. Can anyone convert the SQL easily into MySQL speak? Am I right in thinking that the syntax shown is Oracle?
my $ST = $DB->prepare(<<EOSQL); SELECT ?, ?, A.entity_name FROM e_annotation_090812.annotation A join e_annotation_090812.Temp_table T on T.Line=A.user where length(A.entity_name)>0 and ( length(A.evidence_code)<12 or substr(A.evidence_code,length(A.evidence_code)-2,1)!='8') ) and (A.centre=? or A.centre=?) EOSQL $ST->execute($Reference, $Comparitor, ".$Reference.", ".$Comparitor.")
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: s/Perl/SQL/ ?
by roboticus (Chancellor) on Sep 10, 2012 at 15:47 UTC | |
by Anonymous Monk on Sep 10, 2012 at 19:43 UTC | |
by roboticus (Chancellor) on Sep 10, 2012 at 22:33 UTC | |
Re^3: s/Perl/SQL/ ?
by Corion (Patriarch) on Sep 10, 2012 at 14:39 UTC |
In Section
Seekers of Perl Wisdom