- 博客(25)
- 收藏
- 关注
![](https://csdnimg.cn/release/blogv2/dist/pc/img/listFixedTop.png)
原创 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
4925
1
![](https://csdnimg.cn/release/blogv2/dist/pc/img/listFixedTop.png)
原创 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
2821
2
![](https://csdnimg.cn/release/blogv2/dist/pc/img/listFixedTop.png)
原创 ORACLE写一函数,准确地判断字段是否含有汉字或者提取汉字等
从表里提取汉字, 需要考虑字符集, 不同的字符集汉字的编码有所不同这里以GB2312为例, 写一函数准确地从表里提取简体汉字.假设数据库字符集编码是GB2312, 环境变量(注册表或其它)的字符集也是GB2312编码并且保存到表里的汉字也都是GB2312编码的那么也就是汉字是双字节的,且简体汉字的编码范围是B0A1 - F7FE换算成10进制就是B0 A1 F7 FE176,161 -
2008-01-11 10:12:00
4276
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
2499
转载 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
1598
原创 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
1201
原创 Linux 裸设备基础知识
我的归纳1、裸设备定义:一块没有分区的硬盘,称为原始设备(RAW DEVICE)或者是一个分区,但是没有用EXT3,OCFS等文件系统格式化,称为原始分区(RAW PARTITION)以上两者都是裸设备2、裸设备的绑定有文件系统的分区是采用mount的方式挂载到某一个挂载点的(目录)而裸设备不能mount,只能绑定到/dev/raw/下的某一个设备名比如/dev/raw/raw13、裸设备的绑定方
2008-01-11 13:35:00
927
原创 忘记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
838
原创 在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
1832
原创 对照Oracle,MySQL的几个实用字符串函数
1、concat()函数 1.1 MySQL的concat函数可以连接一个或者多个字符串,如 mysql> select concat(10); +--------------+ | concat(10) | +--------------+ | 10 | +--------------+
2008-01-11 11:08:00
1192
原创 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
1054
原创 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
1000
原创 aa
有个酒吧老板,怕客人们喝多了酒闹事,于是在店里养了一只大猩猩,遇到喝多了的客人,老板就放出猩猩来,把闹事的客人扔到停车场去。 一天,来了个五大三粗的农夫,喝酒喝多了,真的闹了起来,店主实在没办法,只得把猩猩放出来。 当猩猩把农夫揪扯到屋外的时候,传来了一阵乒乒乓乓的声音。 过了一会,农夫歪歪斜斜的走了进来,说道:“有的人.......哼,只不过穿了件皮大衣,就自以为很了不起!
2006-10-27 14:28:00
803
原创 SDFSDF
我会在某一个目录下每天生成一个以YYYY-MM-DD开头的文件。现在需要一个脚本来处理发现是前40天以前的文件就删除,从文件名来判断时间,而不是文件的最后修改时间!CV
2006-10-20 15:53:00
1018
原创 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
1160
原创 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
1279
原创 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
1188
原创 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
986
原创 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
961
原创 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
1165
原创 tree
Rem Rem $Header: utldtree.sql,v 1.2 1992/10/26 16:24:44 RKOOI Stab $ Rem Rem Copyright (c) 1991 by Oracle Corporation Rem NAMERem deptree.sql - Show objects recursively dependent on given obj
2006-09-25 23:18:00
1153
原创 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
1235
原创 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
1177
原创 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
1211
原创 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
1344
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人