ATGC-CSDN博客

原创 MySQL高效的批插入 BULK INSERT

MySQL的批插入 BULK INSERT和load data的速炔畈欢啵⑶铱煽俊?/p> 语法如下假设有表test (ID NUMBER,NAME VARCHAR(10))insert into test values(1,aa),(2,bb),.....(100000,bb);也就是每个记录间用逗号隔开，最后用分号结束，插入10万条记录只需不到10秒

2008-01-12 16:57:00 4914 1

原创 translate函数的用法

以下内容是我在别的贴子上回答的,供参考http://www.itpub.net/showthread.php...light=TRANSLATEhttp://www.itpub.net/showthread.php...10&pagenumber=1select translate(采sg大gd型矩gd阵356式服][12,0123456789||采sg大gd型矩gd阵356式服][12

2008-01-11 10:57:00 2809 2

原创 ORACLE写一函数，准确地判断字段是否含有汉字或者提取汉字等

从表里提取汉字, 需要考虑字符集, 不同的字符集汉字的编码有所不同这里以GB2312为例, 写一函数准确地从表里提取简体汉字.假设数据库字符集编码是GB2312, 环境变量(注册表或其它)的字符集也是GB2312编码并且保存到表里的汉字也都是GB2312编码的那么也就是汉字是双字节的，且简体汉字的编码范围是B0A1 - F7FE换算成10进制就是B0 A1 F7 FE176,161 -

2008-01-11 10:12:00 4236 1

原创 Oracle分隔字符串后输出(列转行)

create or replace type acc_type as object(acc varchar2(50))/create or replace type acc_table as table of acc_type/create or replace function str2table (acc_str in varchar2) return acc_table pipeli

2008-01-12 16:23:00 2492

转载 MySQL的XML函数，摘自http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html

By Alexander Barkov and Peter GulutzanMySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.Lets make a database and put two XML documents in it.

2008-01-12 15:29:00 1590

原创 MySQL的动态SQL

MySQL版本5.0.13以上create table aa (id int);delimiter //create procedure test(v_sql varchar(200))beginset @sqltext:=concat(insert into aa ,v_sql);prepare stmt from @sqltext;execute stmt;DEALLOCA

2008-01-12 14:25:00 1193

我的归纳1、裸设备定义：一块没有分区的硬盘，称为原始设备(RAW DEVICE)或者是一个分区，但是没有用EXT3,OCFS等文件系统格式化,称为原始分区(RAW PARTITION)以上两者都是裸设备2、裸设备的绑定有文件系统的分区是采用mount的方式挂载到某一个挂载点的(目录)而裸设备不能mount，只能绑定到/dev/raw/下的某一个设备名比如/dev/raw/raw13、裸设备的绑定方

2008-01-11 13:35:00 907

原创忘记MYSQL密码的解决方案

一、Window1、net stop mysql 停止mysql服务2、执行mysqld-nt --skip-grant-tables这样启动，不需要密码就可以进入MySQL了3、此时打开一个新的命令窗口，执行mysql，进入MySQL4、修改root密码use mysqlupdate user set password=password(NEW PASSWORD) where user=r

2008-01-11 13:30:00 830

原创在oracle数据库保存图片的方法

方法一E:photo>dirVolume in drive E is New VolumeVolume Serial Number is F816-C39FDirectory of E:photo2007-10-31 11:00 .2007-10-31 11:00 ..2007-08-13 16:19 1,212,681 flower.jpg1 File(s) 1,212,681

2008-01-11 13:27:00 1820

原创对照Oracle，MySQL的几个实用字符串函数

1、concat()函数 1.1 MySQL的concat函数可以连接一个或者多个字符串,如 mysql> select concat(10); +--------------+ | concat(10) | +--------------+ | 10 | +--------------+

2008-01-11 11:08:00 1182

原创 QQQ

有关transport tablespace的测试全过程transport tablespace 测试全过程,数据库oracle9.2.0.4,操作系统平台hp11i,16个cpu,16g内存1.建立测试表空间create tablespace tts_test datafile /dev/vgjs03/rjsdata00274 size 2046m reuse extent manage

2006-11-01 16:31:00 1044

原创 XLS

#!/usr/bin/perl -w#function: select records from table and print to Excel file#author: ATGC#version: 1.0#date of compilation September 6,2004use strict;use Win32

2006-10-31 21:53:00 990

原创 aa

有个酒吧老板，怕客人们喝多了酒闹事，于是在店里养了一只大猩猩，遇到喝多了的客人，老板就放出猩猩来，把闹事的客人扔到停车场去。一天，来了个五大三粗的农夫，喝酒喝多了，真的闹了起来，店主实在没办法，只得把猩猩放出来。当猩猩把农夫揪扯到屋外的时候，传来了一阵乒乒乓乓的声音。过了一会，农夫歪歪斜斜的走了进来，说道：“有的人.......哼，只不过穿了件皮大衣，就自以为很了不起！

2006-10-27 14:28:00 795

原创 SDFSDF

我会在某一个目录下每天生成一个以YYYY－MM－DD开头的文件。现在需要一个脚本来处理发现是前40天以前的文件就删除，从文件名来判断时间，而不是文件的最后修改时间！CV

2006-10-20 15:53:00 998

原创 POSITON

/* * $Id: ComplexText.java,v 1.3 2005/05/09 11:52:08 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address:

2006-09-30 14:25:00 1150

原创 actions

/* * $Id: OutlineActions.java,v 1.4 2005/05/09 11:52:45 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following addres

2006-09-26 12:31:00 1270

原创 goto_2

/* * $Id: Actions.java,v 1.4 2005/05/09 11:52:44 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address: *

2006-09-26 12:27:00 1177

原创 HREF

/* * $Id: AHref.java,v 1.5 2005/05/09 11:52:44 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address: *

2006-09-26 12:25:00 979

原创 GOTO

/* * $Id: LocalGoto.java,v 1.5 2005/05/09 11:52:44 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address:

2006-09-26 12:21:00 953

原创 ftp

#!/usr/bin/perl#function: Copy a batch of files to another host by ftp at an specified time#author: atgc#version: 1.0#date of compilation December 15,2003#OS envir

2006-09-25 23:22:00 1159

原创 tree

2006-09-25 23:18:00 1147

原创 destination

/* * $Id: Destinations.java,v 1.3 2005/05/09 11:52:45 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address:

2006-09-22 00:27:00 1224

原创 LINE

/* * $Id: Lines.java,v 1.5 2005/05/09 11:52:48 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address: * ht

2006-09-21 16:28:00 1169

原创 EVENTS

/* * $Id: Events.java,v 1.5 2005/11/29 16:00:17 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following address:

2006-09-21 16:25:00 1204

原创 PAGENUMBER

/* * $Id: PageNumbersWatermark.java,v 1.3 2005/05/09 11:52:50 blowagie Exp $ * $Name: $ * * This code is part of the iText Tutorial. * You can find the complete tutorial at the following

2006-09-20 12:13:00 1335

ATGC的专栏