- 类目树迭代查询语句
/*根据类目ID查询所有子类目,向下递归*/
select count (*)
from prod_data2.category
start with id = 5135
connect by category_parent_id = prior id
<pre name="code" class="sql"> /*根据类目ID查询所有父级类目,向上递归*/
select count (*)
FROM prod_data2.CATEGORY
start with id = 5135
connect by category_parent_id = id
2、删除数据库索引
SQL:
drop
index
UK_BRAND_NAME;