KIN ORACLE

原创 SQL-韩信点兵

WITH o AS( SELECT LEVEL rn FROM dual WHERE LEVEL >= 60000 CONNECT BY LEVEL <= 150000), result AS( SELECT rn FROM o WHERE MOD(rn, 3)= 2 AND MOD(rn, 5)= 3 AND MOD(rn, 7)= 4 AND MO

原创 Kettle convert mysql datetime '0000-00-00 000000' to Null

原创 MySQL-mysqldump backup script

#!/bin/bash################################################################################### purpose:mysqldump script # version:v1.0# date :2013-07-01# author :kin zhang#####################