mysql -e "hogehoge"でワンライナー
http://d.hatena.ne.jp/lurker/20070219/1171897043
を見ていて(本題ではないところで)
mysql -e "hogehoge"
でワンライナーできることを初めて知った。
[mako@Akari]mysql -e "select display_id, transcript_stable_id, rank, chr_name, exon_chrom_start, exon_chrom_end from hsapiens_gene_ensembl_structure__structure__main WHERE display_id LIKE 'IGF2_HUMAN';" -A -u anonymous -h ensembldb.ensembl.org -D ensembl_mart_42 +------------+----------------------+------+----------+------------------+----------------+ | display_id | transcript_stable_id | rank | chr_name | exon_chrom_start | exon_chrom_end | +------------+----------------------+------+----------+------------------+----------------+ | IGF2_HUMAN | ENST00000381395 | 4 | 11 | 2106918 | 2111029 | | IGF2_HUMAN | ENST00000381395 | 3 | 11 | 2111323 | 2111471 | | IGF2_HUMAN | ENST00000381395 | 2 | 11 | 2113173 | 2113335 | | IGF2_HUMAN | ENST00000381395 | 1 | 11 | 2114994 | 2115096 | | IGF2_HUMAN | ENST00000381406 | 4 | 11 | 2106918 | 2111029 | | IGF2_HUMAN | ENST00000381406 | 3 | 11 | 2111323 | 2111471 | | IGF2_HUMAN | ENST00000381406 | 2 | 11 | 2113173 | 2113335 | | IGF2_HUMAN | ENST00000381406 | 1 | 11 | 2116035 | 2117195 | | IGF2_HUMAN | ENST00000381389 | 4 | 11 | 2110479 | 2111029 | | IGF2_HUMAN | ENST00000381389 | 3 | 11 | 2111323 | 2111471 | | IGF2_HUMAN | ENST00000381389 | 2 | 11 | 2113173 | 2113335 | | IGF2_HUMAN | ENST00000381389 | 1 | 11 | 2118663 | 2118822 | | IGF2_HUMAN | ENST00000356578 | 4 | 11 | 2110522 | 2111029 | | IGF2_HUMAN | ENST00000356578 | 3 | 11 | 2111323 | 2111471 | | IGF2_HUMAN | ENST00000356578 | 2 | 11 | 2113173 | 2113335 | | IGF2_HUMAN | ENST00000356578 | 1 | 11 | 2114998 | 2115111 | | IGF2_HUMAN | ENST00000300632 | 4 | 11 | 2110540 | 2111029 | | IGF2_HUMAN | ENST00000300632 | 3 | 11 | 2111323 | 2111471 | | IGF2_HUMAN | ENST00000300632 | 2 | 11 | 2113173 | 2113335 | | IGF2_HUMAN | ENST00000300632 | 1 | 11 | 2125372 | 2125616 | +------------+----------------------+------+----------+------------------+----------------+
わー、ホントだ。
id:lurkerさん、ありがとう。