- 浏览: 74768 次
- 性别:
- 来自: 南京
最新评论
文章列表
我的CSDN博客地址:http://blog.csdn.net/qidong7
function logout(){
if(confirm("确定要退出吗?")){
var browserName=navigator.appName;
if (browserName=="Netscape"){
alert('chrome');
window.open('', '_self', ' ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
1、新建 .reg 文件(如deleteSVN.reg)
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN]
@="Delete SVN Folders"
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\DeleteSVN\command]
@="cmd.exe /c ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
select * from
(select t.postid,
t.name,
t.parentid
from gaus_postinfo t
start with t.parentid ='GAUS_POSTINFO_8e29081b-8cba-41be-a1da-fdba0ba94a86'
connect by prior t.postid = t.parentid
)treeTable
--查看树
select * from
...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
1、
从叶子节点依据id=pid的关系向上递归到跟节点。
select t.*, t.rowid from indicators t start with (t.isleaf='1' and t.rid='26020')
connect by prior t.pid = t.id order by t.inum
从跟节点依据id=pid的关系向下递归至叶子节点.
select t.*, t.rowid from indicators t start with (t.pid='0' ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
1、插入数据
insert into table_name(cloumn1,column2,...)
values(value1,value2,...)
insert into table_name
values(value1,value2,...)
2、复制表结构
create table
as
select * from dept where 1=0;
3、复制行
insert into table_name(column1,column2,...)
...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
1、order by
select name,sal,comm
from emp
order by 3; -- comm
2、空值排序、或者空值排在前面或后面
使用 case 来标记
select ename,sal,common
from(
select ename,sal,common,
case when common is null then 0
else 1
end as is_null
from emp
) x
order by is_nu ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
1、
and 的优先级 高于 or
2、as
select sal as salary, comm as commission
from emp
3、连接字符串
Oracle/DB2/PostgreSQL:
select ename||' WORKS AS A '||job as msg from emp where deptno=10;
mysql
select concat(ename,'WORKS AS A',job ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestWar" default="run" basedir=".">
<description>
通过拷贝的方式发布项目
</description>
<property name="TOMCAT_HOM ...
请关注新浪微博 账号:大数据进行时(http://weibo.com/u/3272022684)
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestOther" default="run" basedir=".">
<description>
测试其他的ant功能
</description>
<!-- 获取时间 -->
<t ...
<?xml version="1.0" encoding="UTF-8"?>
<!-- basedir 是上一层目录 E:\myworkspace\AntSql\ant -->
<project name="TestFileOperation" default="run" basedir="..">
<property name="src" value="./temp/src"/>
<pr ...
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestWar" default="war" basedir=".">
<description>
打WAR包
</description>
<property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0 ...
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestJavaDoc" default="run" basedir=".">
<property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0.18" />
<property name="JAVA_HOM ...
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestJar" default="run" basedir=".">
<property name="TOMCAT_HOME" value="E:/work/my-project-apache-tomcat-6.0.18" />
<property name="JAVA_HOME ...
<?xml version="1.0" encoding="UTF-8"?>
<project name="TestCompile" default="run" basedir=".">
<description>
如何编译java文件
</description>
<property name="TOMCAT_HOME" value="E:/work/my-project-apache-t ...
build.bat文件:
:: 配置 ant 需要的环境变量
@echo off
SET TOMCAT_HOME=E:\work\my-project-apache-tomcat-6.0.18
SET DEPENDS_HOME=E:\myworkspace\AntSql\depends
SET OUTPUT_HOME=E:\myworkspace\AntSql\build\output
SET PROJECT_HOME=E:\myworkspace\AntSql
:: 当前目录下的build.xml
ant
@echo on
build.xml 文件
<?xml versio ...