摘要:
1 CREATE TABLE A LIKE B此种方式在将表B复制到A时候会将表B完整的字段结构和索引复制到表A中来。2. CREATE TABLE A AS SELECT * FROM B此种方式只会将表B的字段结构复制到表A中来,但不会复制表B中的索引到表A中来。这种方式比较灵活可以在复制原表... 阅读全文
摘要:
Windows 下 ORA-12560: TNS: 协议适配器错误的问题原因有三个:1.监听服务没有起起来。windows平台个一如下操作:开始---程序---管理工具---服务,打开服务面板,启动oraclehome92TNSlistener服务。2.database instance没有起起来。... 阅读全文
摘要:
创建表(Create table)语法详解1.ORACLE常用的字段类型ORACLE常用的字段类型有VARCHAR2 (size) 可变长度的字符串, 必须规定长度CHAR(size) 固定长度的字符串, 不规定长度默认值为1NUMBER(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... 阅读全文