<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ATGC的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/ATGC</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; ATGC]]></copyright><item><title><![CDATA[MySQL高效的批插入 BULK INSERT]]></title><link>https://blog.csdn.net/ATGC/article/details/2039672</link><guid>https://blog.csdn.net/ATGC/article/details/2039672</guid><author>ATGC</author><pubDate>Sat, 12 Jan 2008 16:57:00 +0800</pubDate><description><![CDATA[MySQL的批插入 BULK INSERT和load data的速炔畈欢啵⑶铱煽俊?/p> 语法如下假设有表test (ID NUMBER,NAME VARCHAR(10))insert into test values(1,aa),(2,bb),.....(100000,bb);也就是每个记录间用逗号隔开，最后用分号结束，插入10万条记录只需不到10秒 ]]></description><category></category></item><item><title><![CDATA[Oracle分隔字符串后输出(列转行)]]></title><link>https://blog.csdn.net/ATGC/article/details/2039603</link><guid>https://blog.csdn.net/ATGC/article/details/2039603</guid><author>ATGC</author><pubDate>Sat, 12 Jan 2008 16:23:00 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[MySQL的XML函数，摘自http://dev.mysql.com/tech-resources/articles/mysql-5.1-xml.html ]]></title><link>https://blog.csdn.net/ATGC/article/details/2039456</link><guid>https://blog.csdn.net/ATGC/article/details/2039456</guid><author>ATGC</author><pubDate>Sat, 12 Jan 2008 15:29:00 +0800</pubDate><description><![CDATA[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.]]></description><category></category></item><item><title><![CDATA[MySQL的动态SQL]]></title><link>https://blog.csdn.net/ATGC/article/details/2039338</link><guid>https://blog.csdn.net/ATGC/article/details/2039338</guid><author>ATGC</author><pubDate>Sat, 12 Jan 2008 14:25:00 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[Linux 裸设备基础知识]]></title><link>https://blog.csdn.net/ATGC/article/details/2037235</link><guid>https://blog.csdn.net/ATGC/article/details/2037235</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 13:35:00 +0800</pubDate><description><![CDATA[我的归纳1、裸设备定义：一块没有分区的硬盘，称为原始设备(RAW DEVICE)或者是一个分区，但是没有用EXT3,OCFS等文件系统格式化,称为原始分区(RAW PARTITION)以上两者都是裸设备2、裸设备的绑定有文件系统的分区是采用mount的方式挂载到某一个挂载点的(目录)而裸设备不能mount，只能绑定到/dev/raw/下的某一个设备名比如/dev/raw/raw13、裸设备的绑定方]]></description><category></category></item><item><title><![CDATA[忘记MYSQL密码的解决方案]]></title><link>https://blog.csdn.net/ATGC/article/details/2037223</link><guid>https://blog.csdn.net/ATGC/article/details/2037223</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 13:30:00 +0800</pubDate><description><![CDATA[一、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]]></description><category></category></item><item><title><![CDATA[在oracle数据库保存图片的方法]]></title><link>https://blog.csdn.net/ATGC/article/details/2037214</link><guid>https://blog.csdn.net/ATGC/article/details/2037214</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 13:27:00 +0800</pubDate><description><![CDATA[方法一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 ]]></description><category></category></item><item><title><![CDATA[对照Oracle，MySQL的几个实用字符串函数]]></title><link>https://blog.csdn.net/ATGC/article/details/2036950</link><guid>https://blog.csdn.net/ATGC/article/details/2036950</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 11:08:00 +0800</pubDate><description><![CDATA[1、concat()函数   1.1 MySQL的concat函数可以连接一个或者多个字符串,如       mysql> select concat(10);       +--------------+       | concat(10) |       +--------------+       | 10           |       +--------------+   ]]></description><category></category></item><item><title><![CDATA[translate函数的用法]]></title><link>https://blog.csdn.net/ATGC/article/details/2036918</link><guid>https://blog.csdn.net/ATGC/article/details/2036918</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 10:57:00 +0800</pubDate><description><![CDATA[以下内容是我在别的贴子上回答的,供参考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]]></description><category></category></item><item><title><![CDATA[ORACLE写一函数，准确地判断字段是否含有汉字或者提取汉字等]]></title><link>https://blog.csdn.net/ATGC/article/details/2036799</link><guid>https://blog.csdn.net/ATGC/article/details/2036799</guid><author>ATGC</author><pubDate>Fri, 11 Jan 2008 10:12:00 +0800</pubDate><description><![CDATA[从表里提取汉字, 需要考虑字符集, 不同的字符集汉字的编码有所不同这里以GB2312为例, 写一函数准确地从表里提取简体汉字.假设数据库字符集编码是GB2312, 环境变量(注册表或其它)的字符集也是GB2312编码并且保存到表里的汉字也都是GB2312编码的那么也就是汉字是双字节的，且简体汉字的编码范围是B0A1 - F7FE换算成10进制就是B0  A1    F7  FE176,161 - ]]></description><category></category></item><item><title><![CDATA[QQQ]]></title><link>https://blog.csdn.net/ATGC/article/details/1360931</link><guid>https://blog.csdn.net/ATGC/article/details/1360931</guid><author>ATGC</author><pubDate>Wed, 01 Nov 2006 16:31:00 +0800</pubDate><description><![CDATA[有关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]]></description><category></category></item><item><title><![CDATA[XLS]]></title><link>https://blog.csdn.net/ATGC/article/details/1359270</link><guid>https://blog.csdn.net/ATGC/article/details/1359270</guid><author>ATGC</author><pubDate>Tue, 31 Oct 2006 21:53:00 +0800</pubDate><description><![CDATA[#!/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]]></description><category></category></item><item><title><![CDATA[aa]]></title><link>https://blog.csdn.net/ATGC/article/details/1353270</link><guid>https://blog.csdn.net/ATGC/article/details/1353270</guid><author>ATGC</author><pubDate>Fri, 27 Oct 2006 14:28:00 +0800</pubDate><description><![CDATA[有个酒吧老板，怕客人们喝多了酒闹事，于是在店里养了一只大猩猩，遇到喝多了的客人，老板就放出猩猩来，把闹事的客人扔到停车场去。 一天，来了个五大三粗的农夫，喝酒喝多了，真的闹了起来，店主实在没办法，只得把猩猩放出来。 当猩猩把农夫揪扯到屋外的时候，传来了一阵乒乒乓乓的声音。 过了一会，农夫歪歪斜斜的走了进来，说道：“有的人.......哼，只不过穿了件皮大衣，就自以为很了不起！ ]]></description><category></category></item><item><title><![CDATA[SDFSDF]]></title><link>https://blog.csdn.net/ATGC/article/details/1342792</link><guid>https://blog.csdn.net/ATGC/article/details/1342792</guid><author>ATGC</author><pubDate>Fri, 20 Oct 2006 15:53:00 +0800</pubDate><description><![CDATA[我会在某一个目录下每天生成一个以YYYY－MM－DD开头的文件。现在需要一个脚本来处理发现是前40天以前的文件就删除，从文件名来判断时间，而不是文件的最后修改时间！CV ]]></description><category></category></item><item><title><![CDATA[POSITON]]></title><link>https://blog.csdn.net/ATGC/article/details/1311799</link><guid>https://blog.csdn.net/ATGC/article/details/1311799</guid><author>ATGC</author><pubDate>Sat, 30 Sep 2006 14:25:00 +0800</pubDate><description><![CDATA[/* * $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:]]></description><category></category></item><item><title><![CDATA[actions]]></title><link>https://blog.csdn.net/ATGC/article/details/1286859</link><guid>https://blog.csdn.net/ATGC/article/details/1286859</guid><author>ATGC</author><pubDate>Tue, 26 Sep 2006 12:31:00 +0800</pubDate><description><![CDATA[/* * $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]]></description><category></category></item><item><title><![CDATA[goto_2]]></title><link>https://blog.csdn.net/ATGC/article/details/1286836</link><guid>https://blog.csdn.net/ATGC/article/details/1286836</guid><author>ATGC</author><pubDate>Tue, 26 Sep 2006 12:27:00 +0800</pubDate><description><![CDATA[/* * $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: * ]]></description><category></category></item><item><title><![CDATA[HREF]]></title><link>https://blog.csdn.net/ATGC/article/details/1286826</link><guid>https://blog.csdn.net/ATGC/article/details/1286826</guid><author>ATGC</author><pubDate>Tue, 26 Sep 2006 12:25:00 +0800</pubDate><description><![CDATA[ /* * $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: *]]></description><category></category></item><item><title><![CDATA[GOTO]]></title><link>https://blog.csdn.net/ATGC/article/details/1286806</link><guid>https://blog.csdn.net/ATGC/article/details/1286806</guid><author>ATGC</author><pubDate>Tue, 26 Sep 2006 12:21:00 +0800</pubDate><description><![CDATA[/* * $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: ]]></description><category></category></item><item><title><![CDATA[ftp]]></title><link>https://blog.csdn.net/ATGC/article/details/1282932</link><guid>https://blog.csdn.net/ATGC/article/details/1282932</guid><author>ATGC</author><pubDate>Mon, 25 Sep 2006 23:22:00 +0800</pubDate><description><![CDATA[#!/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]]></description><category></category></item></channel></rss>