Find The Number Of Simple Repeats On The Y Chromosome

Question

[zhaolin20042008]

I am trying to find the number of simple repeats on the Y chromosome using UCSC mysql query.

use hg19;

select count (sequence) as Numberofrepeats

from simpleRepeat where chrom = 'chrY';

The result showed "ERROR1630(4200): Function hg19.count does not exist. check the 'Funciton Name Parsing and Resolution' section in the reference manual".

If select count doesn't work, what is the commander used for replacement? Is the the reference manual online? Could anyone give me a link? Thank you.

Answer 1

[Sean Davis]

You have a space between count and the parentheses. This works fine for me:

select count(sequence) as Numberofrepeats from simpleRepeat where chrom='chrY';

[zhaolin20042008]

Yes. It works now. Thank you.