Skip to content

Instantly share code, notes, and snippets.

cd /mysql/bin
mysqld install
<!doctype html>
<html>
<head>
<title>JS1k, 1k demo submission [1022]</title>
<meta charset="utf-8" />
</head>
<body>
<canvas id="can"></canvas>
<script>
var b = document.body;
@bianle
bianle / centos.security.sh
Created June 28, 2016 01:13
centos安全配置
#!/bin/sh
# desc: setup linux system security
#account setup
passwd -l xfs
passwd -l news
passwd -l nscd
passwd -l dbus
passwd -l vcsa
passwd -l games
passwd -l nobody
@bianle
bianle / oracle函数整理.txt
Last active December 11, 2018 00:49
oracle函数整理
SQL中的单记录函数
1.ASCII
返回与指定的字符对应的十进制数;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
@bianle
bianle / win7开机自启动方法大全.md
Last active June 23, 2016 08:15
win7开机自启动方法大全

启动文件夹(有两个)

  • C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Startup

【在注册表里的位置(可更改)】

[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\explorer\User   Shell   Folders]   
\ "Common   Startup\ "=\ "%Directory%\ "   
[HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\explorer\Shell   Folders]   
\ "Common   Startup\ "=\ "%Directory%\ "  
@bianle
bianle / 递归.sql
Created June 22, 2016 09:50
db2递归
with n(level,function_privi_id,parent_function_id,function_privi_name,id_chain) as (
select 1,function_privi_id,parent_function_id,function_privi_name,cast(function_privi_id as varchar(300))||','
from t_sys_function_privi
where parent_function_id = '10'
union all
select n.level+1,nplus1.function_privi_id,nplus1.parent_function_id ,nplus1.function_privi_name,n.id_chain||nplus1.function_privi_id||','
from t_sys_function_privi as nplus1,n
where n.function_privi_id = nplus1.parent_function_id
)
select * from n order by id_chain
@bianle
bianle / 修改sequence.sql
Last active June 22, 2016 09:50
基本操作
alter sequence seq_id restart with 100154073
@bianle
bianle / 恢复表.sql
Created June 22, 2016 09:45
备份/恢复表
drop table PORTAL.T_SYS_FUNCTION_PRIVI;
create table PORTAL.T_SYS_FUNCTION_PRIVI as (select * from PORTAL.T_SYS_FUNCTION_PRIVI_0513)
data initially deferred
refresh deferred;
refresh table PORTAL.T_SYS_FUNCTION_PRIVI;
alter table PORTAL.T_SYS_FUNCTION_PRIVI drop materialized query;
drop table PORTAL.T_SYS_FUNCTION_REPORT;
create table PORTAL.T_SYS_FUNCTION_REPORT as (select * from PORTAL.T_SYS_FUNCTION_REPORT_0513)
data initially deferred
@bianle
bianle / XlsReader.java
Created June 22, 2016 09:41
java读取excel
package tools.file.xls;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
@bianle
bianle / inheritance.js
Created June 9, 2016 14:29 — forked from adohe-zz/inheritance.js
A classic inheritance implementation in Node.js
/**
* A classic inheritance implementation in Node.js
*
*/
var util = require('util');
var Parent = require('./Parent');
function Child(/* [options, ] cb*/) {
if (!(this instanceof Child)) return new Child(arguments[0], arguments[1]);