> This is the first level of quoting.
>
> > This is nested blockquote.
>
> Back to the first level.
This is the first level of quoting. >
> This is the first level of quoting.
>
> > This is nested blockquote.
>
> Back to the first level.
This is the first level of quoting. >
Ctrl+Shift+A
元快捷键
Ctrl+W
选择
(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); | |
//嵌套关系数据库,拼接结果集 |
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; |