debian部署 个人环境部署 apt-get install sudo apt-get install vim vim /etc/sudoers #增加 shagon ALL=(ALL:ALL) NOPASSWD:ALL sudo vim /etc/vim/vimrc #去掉 syntax on 前的注释 set tabstop=4 set softtabstop=4 colorscheme desert vim /home/shagon/.ssh/authorized_keys #增加本地密钥 #安装 oh-my-zsh sudo apt-get install zsh sudo apt-get install git sh -c "$(wget https://raw.github.com/robbyrussell/oh-my-zsh/master/tools/install.sh -O -)" s... 2017-10-30
mysql 列值转换和统计 将 user_sample uid 201608 201609 201610 201611 张三 iPhone mi mi Google 李四 mi mi Google Google 王五 Google mi iPhone iPhone 转换为 phone_result uid iPhone mi Google 张三 1 2 1 李四 0 2 2 王五 2 1 1 sql 如下： drop table if exists tmp; drop table if exists phone_result; create table tmp as select uid, `201608` as brand, `201608` as month from `user_sample`; insert into tmp select uid, `201609` as brand, `201609` as... 2017-09-13
62进制转换 //十进制转为 62 进制 function encode62($number) { $base = 62; $index = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; $ret = ''; for ($t = floor(log10($number) / log10($base)); $t >= 0; $t--) { $a = floor($number / pow($base, $t)); $ret .= substr($index, $a, 1); $number -= $a * pow($base, $t); } return $ret; } //62 进制转为十进制 function decode... 2017-08-31