摘要：thunder://QUFodHRwOi8veGlhemFpLnhpYXphaWJhLmNvbS9Tb2Z0L04vTmF2aWNhdF9QcmVtaXVtXzEwLjEuN19YaWFaYWlCYS5leGVaWg==首先下载navicat 10 安装到本地http://119.188.72.52/0/ishare.down.sina.com.cn/27621454.zip?ssig=FKW8Vmty8q&Expires=1366473600&KID=sina,ishare&ip=1366336535,116.90.82.&fn=instantclient-b 阅读全文

摘要：oracle递归查询父select*fromKM_PROCESSpstartwithp.WB_ID='20130423055636'connectbypriorp.PARENT_WBS_CODE=p.WB_IDoracle递归查询子select*fromKM_PROCESSpstartwithp.WB_ID='20130423055636'connectbypriorp.WB_ID=p.PARENT_WBS_CODE 阅读全文

摘要：desc表名;showcolumnsfrom表名;describe表名;showcreatetable表名;useinformation_schemaselect*fromcolumnswheretable_name='表名';顺便记下：showdatabases;use数据库名;showtables;原有一unique索引AK_PAS_Name(PAC_Name)在表tb_webparamcounter中，执行以下sql修改索引altertabletb_webparamcounterdropindexAK_PAS_Name;altertabletb_webparamcount 阅读全文