![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB & SQL
iteye_20852
这个作者很懒,什么都没留下…
展开
-
SQL小技巧
1. MSSQL: field: 默认nullable, primate key 被指定"NOT NULL". 不可以用"DROP TABLE IF EXISTS". 2. 通用SQL函数 连接函数: CONCAT(FIRST_NAME,' ',LAST_NAME) AS FULL_NAME原创 2008-08-21 20:16:15 · 72 阅读 · 0 评论 -
Left Join & Right Join & Full Join & Join
Foreword: TBL_BPM_HK_PINS save house keep process instances(contains all outdated pins and uptodate pins), TBL_BPM_PMAP save process maps. Maybe the process map has been deleted, so if want to provide...2008-09-12 22:23:48 · 114 阅读 · 0 评论 -
Oracle SQL 总结
[color=blue]1.SET DEFINE OFF 的用法;[/color] (摘自:http://hi.baidu.com/wanghp/blog/item/50d8a901fa57e4061d9583c6.html) 在SQL*Plus中默认的"&"表示替代变量,也就是说,只要在命令中出现该符号,SQL*Plus就会要你输入替代值。这就意味着你无法将一个含有该符号的字符串输入数据库或...原创 2008-09-14 00:03:50 · 56 阅读 · 0 评论 -
各种数据库的比较
[color=blue]1. sql区别以及对应关系。[/color] mysql oracle DB2 sqlserver Derby XXXXX blob XXXXX image XXXXX XXXXX clob XXXXX text XXXXX date ...原创 2008-09-14 00:28:17 · 102 阅读 · 0 评论 -
Inline method of DB servers
1. CHARINDEX vs INSTR [code="java"]if ("MSSQL".equals(DATABASE_TYPE)) { express = " CHARINDEX(bas.COLUMN_ID,col.expression) "; } else { express = " INSTR(col.expression, bas.COLUMN_ID) "; ...2008-10-17 00:02:11 · 72 阅读 · 0 评论 -
JDBC连接
1、MySQL数据库 Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //or com.mysql.jdbc.Driver String url ="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncodin...原创 2008-10-22 22:03:58 · 89 阅读 · 0 评论