Skip to content

Instantly share code, notes, and snippets.

View Pickman-Model's full-sized avatar

Big-raccoon Pickman-Model

View GitHub Profile
@Pickman-Model
Pickman-Model / Mysql之UNION的使用.sql
Created July 27, 2016 15:19
(select fid,name from addr_tbl where id = (select fid from addr_tbl where id = (select fid from addr_tbl where id = 1)) and dep > 0 ) union (select fid,name from addr_tbl where id = (select fid from addr_tbl where id = 1) ) union (select fid,name from addr_tbl where id = 1);
//嵌套关系数据库，拼接结果集
@Pickman-Model
Pickman-Model / Mysql 版中国省市区数据表.sql
Created July 27, 2016 13:39
Mysql 版中国省市区数据表，单表结构，数据完备和错误需要自己验证
DROP TABLE IF EXISTS `db_yhm_city`;
CREATE TABLE `db_yhm_city` (
`class_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`class_parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`class_name` varchar(120) NOT NULL DEFAULT '',
`class_type` tinyint(1) NOT NULL DEFAULT '2',
PRIMARY KEY (`class_id`),
KEY `class_parent_id` (`class_parent_id`),
KEY `class_type` (`class_type`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
@Pickman-Model
Pickman-Model / CSS文章收集.md
Created May 26, 2016 15:52
@Pickman-Model
Pickman-Model / 《语法俱乐部》--TODO.md
Last active June 19, 2017 19:46
《语法俱乐部》--TODO.md

目录

  • 序

  • 前言

  • 初级句型

    • 第一章 基本句型及补语
    • 第二章 名词词组与冠词
    • 第三章 动词时态

  • 第四章 不定词短语

@Pickman-Model
Pickman-Model / android studio 的几个快捷键.md
Last active January 6, 2016 12:03

Ctrl+Shift+A 元快捷键
Ctrl+W 选择

@Pickman-Model
Pickman-Model / Github-Markdown-多层次块引用示例.md
Created December 26, 2015 14:39 
> This is the first level of quoting.
>
> > This is nested blockquote.
>
> Back to the first level.

This is the first level of quoting. >