<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/shininghunter</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; shininghunter]]></copyright><item><title><![CDATA[DB2 小数点处理]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/41673813</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/41673813</guid><author>shininghunter</author><pubDate>Tue, 02 Dec 2014 09:20:58 +0800</pubDate><description><![CDATA[以保留两位小数为例，代码如下：
select
	--floor
	cast((0.333*1000 - mod(0.333*1000, 10)) / 10 / 100 as decimal(20,2))		as f333,
	cast((0.335*1000 - mod(0.335*1000, 10)) / 10 / 100 as decimal(20,2))		as f335,
	cast((]]></description><category></category></item><item><title><![CDATA[UTF-8字节数]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/41478153</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/41478153</guid><author>shininghunter</author><pubDate>Tue, 25 Nov 2014 10:44:21 +0800</pubDate><description><![CDATA[﻿﻿
UCS-2同UTF-8对应关系如下：

U-00000000 – U-0000007F:
0xxxxxxx
U-00000080 – U-000007FF:
110xxxxx 10xxxxxx
U-00000800 – U-0000FFFF:
1110xxxx 10xxxxxx 10xxxxxx
U-00010000 – U-001FFFFF:
11110xxx 10xx]]></description><category></category></item><item><title><![CDATA[mysqldump导入导出mysql数据库]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/40339005</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/40339005</guid><author>shininghunter</author><pubDate>Tue, 21 Oct 2014 07:38:33 +0800</pubDate><description><![CDATA[数据库的基本导入\导出的命令 是 mysqldump 和 source 在linux下直接用命令行操作就可以 在windows下 一般情况下有两种方法一个也是用命令行 另一个是用phpmyadmin
先来说说phpmyadmin 这个工具导出和导入很简单 而且导入时无需建库 直接还原成原来的数据库 用source 也可以还原 但他导入文件时有大小限制不能超过2M 再来说说 mysqldump 和]]></description><category></category></item><item><title><![CDATA[chrome css hack]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/39202063</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/39202063</guid><author>shininghunter</author><pubDate>Thu, 11 Sep 2014 09:02:41 +0800</pubDate><description><![CDATA[chrome:
@media screen and (-webkit-min-device-pixel-ratio:0){
di.  td span{
width: 
190px;
}
}]]></description><category></category></item><item><title><![CDATA[Chrome CSS hack]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/39202057</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/39202057</guid><author>shininghunter</author><pubDate>Thu, 11 Sep 2014 09:02:28 +0800</pubDate><description><![CDATA[chrome:
@media screen and (-webkit-min-device-pixel-ratio:0){
div.printList thead tr.rowX td,
div.printList thead tr.rowX td span{
width: 
19px;
}
}]]></description><category></category></item><item><title><![CDATA[svn导出某两个版本之间变化的文件]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/34855407</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/34855407</guid><author>shininghunter</author><pubDate>Thu, 26 Jun 2014 16:14:00 +0800</pubDate><description><![CDATA[场景: 代码上线时, 需要将有变动的文件提交到服务器上, 这时候我们只希望取出变动的文件(新增或修改的, 删除的单独处理)

实现:
TortoiseSVN客户端, 用svn show log功能列出所有Revisons记录, 任选两个版本右键选取Compare revisons,
会列出两个版本间差异项目,用鼠标全选右键选择"Export selection to ...",这样就能导出]]></description><category></category></item><item><title><![CDATA[DB2 LPAD的实现方法]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/21326603</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/21326603</guid><author>shininghunter</author><pubDate>Sun, 16 Mar 2014 15:07:46 +0800</pubDate><description><![CDATA[有两种方法可以实现LPAD的功能。
 
13位字符串左边补0： 
right(cast((10000000000000 + "+idx+") as char(14)),13)


 
REPEAT('0',13-idx.length) || idx]]></description><category></category></item><item><title><![CDATA[MySQL导入dump备份]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/18657725</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/18657725</guid><author>shininghunter</author><pubDate>Wed, 22 Jan 2014 11:43:00 +0800</pubDate><description><![CDATA[这里采用的是source 命令导入的方法。
假定dump文件放在D盘。
 
1，登录命令行。
 
2，创建要导入的数据库:
create database dumpin;

3，切换数据库。
use dumpin;

 
4，导入dump备份。
source d：dumpout.dump;
到这就OK了。]]></description><category></category></item><item><title><![CDATA[DB2 查看自定义函数]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/17682813</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/17682813</guid><author>shininghunter</author><pubDate>Mon, 30 Dec 2013 16:11:34 +0800</pubDate><description><![CDATA[--查看自定义函数方法：select funcname, CAST(body AS VARCHAR(3000)) from syscat.functions where funcname = 'FUNCNAME';]]></description><category></category></item><item><title><![CDATA[DB2 merge into 备忘]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/15338279</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/15338279</guid><author>shininghunter</author><pubDate>Mon, 11 Nov 2013 14:47:09 +0800</pubDate><description><![CDATA[merge into session.EMPLOYE as EM
using (select MA.managerid,MA.name,MA.salary from session.MANAGER as MA where MA.managerid = 6) as MA
on EM.employeid = MA.managerid
when matched and EM.salary < MA]]></description><category></category></item><item><title><![CDATA[DB2查看VIEW定义]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/12782435</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/12782435</guid><author>shininghunter</author><pubDate>Wed, 16 Oct 2013 16:17:16 +0800</pubDate><description><![CDATA[DB2查看VIEW定义的SQL文。
 
select VD.text as V_DLL from syscat.VIEWS as VD where VD.VIEWSCHEMA = 'DB2ADMIN' and VD.VIEWNAME = 'V_DEPT';

字段V_DLL就是VIEW的DLL了。]]></description><category></category></item><item><title><![CDATA[DB2查询表名，字段名]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/10076341</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/10076341</guid><author>shininghunter</author><pubDate>Mon, 19 Aug 2013 16:31:21 +0800</pubDate><description><![CDATA[留下来备忘。
DB2查询表名，字段名
SELECT
    C.TABSCHEMA,
    C.TABNAME,
    C.COLNAME
FROM
    SYSCAT.TABLES AS T,
    SYSCAT.COLUMNS AS C
WHERE
    T.TBSPACEID = 2--表空间ID
AND T.TABLEID = 4120--表IDAND C.COLNO = 1]]></description><category></category></item><item><title><![CDATA[left jion 中on 和 where 的执行过程]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/8858699</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/8858699</guid><author>shininghunter</author><pubDate>Sat, 27 Apr 2013 13:36:11 +0800</pubDate><description><![CDATA[数据库在通过连接两张或多张表来返回记录时，都会生成一张中间的临时表，然后再将这张临时表返回给用户。
  在使用left jion时，
on和where条件的区别如下：
   1、on条件是在生成临时表时使用的条件，它不管on中的条件是否为真，都会返回左边表中的记录。
   2、where条件是在临时表生成好后，再对临时表进行过滤的条件。这时已经没有left join的含义（必须返回左边表的]]></description><category></category></item><item><title><![CDATA[DB2错误信息（按sqlcode排序）]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/8001685</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/8001685</guid><author>shininghunter</author><pubDate>Thu, 20 Sep 2012 20:35:49 +0800</pubDate><description><![CDATA[转自http://blog.tianya.cn/blogger/post_read.asp?BlogID=96865&PostID=26978632：

DB2错误信息（按sqlcode排序）
　　sqlcode sqlstate 说明
　　000 00000 SQL语句成功完成
　　01xxx SQL语句成功完成，但是有警告
　　+012 01545 未限定的列名被解释为一个有相互关]]></description><category></category></item><item><title><![CDATA[XCODE编程中查看真机中应用程序的文件]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7644023</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7644023</guid><author>shininghunter</author><pubDate>Fri, 08 Jun 2012 09:24:37 +0800</pubDate><description><![CDATA[有时候开发调试时，需要查看真机中应用的文件，比如Sqlite之类的，可按以下步骤进行：

环境：XCODE 4.3.2 英文版，iPad2。
1）点击XCODE右边的Organizer，出现Organizer画面，再选择Devices ，打开设备一览。
2）点击左边设备一览中的iPad2左边的三角按钮，打开下拉列表，选择Applications应用列表，右边会显示出iPad上的所有第三方应]]></description><category></category></item><item><title><![CDATA[XCODE编程中查看模拟器中应用程序的文件]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7620313</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7620313</guid><author>shininghunter</author><pubDate>Thu, 31 May 2012 16:37:37 +0800</pubDate><description><![CDATA[XCODE编程中查看模拟器中应用程序的文件，比如SQLite文件。


打开 终端（Terminal.app），命令行窗口中输入以下命令：
open ~/Library/
再一步步进入模拟器文件夹，注意选择正确的模拟器版本号。
Library/Application Support/iPhone Simulator/版本号/


再下面就是模拟器详细的文件夹。

Applic]]></description><category></category></item><item><title><![CDATA[Flex移动开发，设置屏幕方向和改变屏幕亮度]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7528232</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7528232</guid><author>shininghunter</author><pubDate>Wed, 02 May 2012 15:31:33 +0800</pubDate><description><![CDATA[设置屏幕方向：
横屏：

this.stage.setAspectRatio(StageAspectRatio.LANDSCAPE);


竖屏：

this.stage.setAspectRatio(StageAspectRatio.PORTRAIT);


改变屏幕亮度：
利用ColorTransform 达到改变亮度的目的。


			//这就是要改变亮度的Vi]]></description><category></category></item><item><title><![CDATA[Array数组的复制]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7498388</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7498388</guid><author>shininghunter</author><pubDate>Wed, 25 Apr 2012 16:14:24 +0800</pubDate><description><![CDATA[Array数组的复制有两种，浅复制和深复制。
浅复制：



var arr2:Array = arr1.slice();或者


var arr2:Array = arr1.concat();
深度复制：利用ByteArray做为中转，


var ba:ByteArray = new ByteArray();
ba.writeObject(arr1);
var arr2]]></description><category></category></item><item><title><![CDATA[在as3中读取C++的64位int]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7302829</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7302829</guid><author>shininghunter</author><pubDate>Tue, 28 Feb 2012 16:40:39 +0800</pubDate><description><![CDATA[var long_b : int;
var long_l : uint;

long_b = ba.readInt();
long_l  = ba.readUnsignedInt();

toNumber:
var Double ： Number = Number (long_b) * (1

Number 是 52位 浮点计数 值域比long大 但精度没long大]]></description><category></category></item><item><title><![CDATA[C/C++中获取数组的长度]]></title><link>https://blog.youkuaiyun.com/shininghunter/article/details/7288021</link><guid>https://blog.youkuaiyun.com/shininghunter/article/details/7288021</guid><author>shininghunter</author><pubDate>Thu, 23 Feb 2012 17:33:46 +0800</pubDate><description><![CDATA[C、C++中没有提供直接获取数组长度的函数，对于存放字符串的字符数组提供了一个strlen函数获取长度，那么对于其他类型的数组如何获取他们的长度呢？其中一种方法是使用sizeof(array) / sizeof(array[0]), 在C语言中习惯上在 使用时都把它定义成一个宏，比如#define GET_ARRAY_LEN(array,len) {len = (sizeof(array) / s]]></description><category></category></item></channel></rss>