摘要：
创建表(Create table)语法详解1.ORACLE常用的字段类型ORACLE常用的字段类型有VARCHAR2 (size) 可变长度的字符串, 必须规定长度CHAR(size) 固定长度的字符串, 不规定长度默认值为１NUMBER(p,s) 数字型p是位数总长度, s是小数的长度, 可存负数... 阅读全文
摘要：
There is nice tool called pv# On Ubuntu/Debian system$ sudo apt-get install pv# On Redhat/CentOS$ sudo yum install pvthen e.g. you can use it like thi... 阅读全文
摘要：
insert的语法INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),... [ ... 阅读全文
摘要：
1.算数运算符 加 mysql> select 1+2; 减 mysql> select 2-1; 乘 mysql> select 2*3; 除 mysql> select 5/3; 商 mysql> SELECT 5 DIV 2; 模 mysql> select 5%2,mod(5,2); 2.比... 阅读全文
摘要：
Speed of INSERT StatementsTo optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection... 阅读全文
摘要：
如果有root权限，可以运行：easy_install argparse如果没有root权限，As a simple solution copy argparse.py from https://code.google.com/p/argparse/source/browse/argparse.py... 阅读全文
摘要：
[1] bedtools (https://github.com/arq5x/bedtools2)here is also bedtools (https://github.com/arq5x/bedtools2) getfasta. It uses Erik's code under the ho... 阅读全文
摘要：
Use a regular expression for filtering sequences by id from a FASTA file, e.g. just certain chromosomes from a genome. There are other toolsas part of... 阅读全文
摘要：
bgzip – Block compression/decompression utilitytabix – Generic indexer for TAB-delimited genome position filesSAMtoolsandBCFtoolsare distributed as in... 阅读全文
摘要：
在linux上格式化一个磁盘分区时，出现如下错误root@d:~#mkfs.ext4/dev/sdb1mke2fs1.41.12(11-May-2015)mkfs.ext4:inode_size(128)*inodes_count(0)toobigforafilesystemwith0blocks,... 阅读全文