![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database
zj23qq
这个作者很懒,什么都没留下…
展开
-
SQL——连接
SQL 的连接(JOIN)语句将数据库中的两个或多个表组合起来.[1] 由"连接"生成的集合, 可以被保存为表, 或者当成表来使用. JOIN 语句的含义是把两张表的属性通过它们的值组合在一起. 基于 ANSI 标准的 SQL 列出了五种 JOIN 方式: 内连接(INNER), 全外连接(FULL OUTER), 左外连接(LEFT OUTER), 右外连接(RIGHT OUTER)转载 2015-07-16 07:36:23 · 430 阅读 · 0 评论 -
JDBC连接数据库
Import JDBC Packages: Add import statements to your Java program to import required classes in your Java code.import java.sql.* ; // for standard JDBC programsimport java.math.* ; // for BigDeci转载 2015-08-31 23:15:06 · 511 阅读 · 0 评论 -
MySQL——存储过程
BEGIN DECLARE detail_id int default 0; DECLARE log_d_score int default 0; DECLARE detail_count int default 0; declare sign int default 0; DECLARE done INT DEFAULT 0; declare cur1 cursor for原创 2015-09-27 15:01:39 · 296 阅读 · 0 评论 -
date_format()的使用
String sql = " select * from tjyx.member a where a.DELETED = 0 and DATE_FORMAT(a.BIRTH_DATE, '%m%d')>=DATE_FORMAT('";sql = sql + start + "', '%m%d') and DATE_FORMAT(a.BIRTH_DATE,'%m%d')<= DATE_FORMA原创 2015-09-24 16:03:31 · 1140 阅读 · 0 评论 -
MySql——delete
delete t1 from tjyx.member_card_balance t1, (select t2.card_no from tjyx.member_card_balance t2,tjyx.member_card t3 where t2.card_no=t3.CARD_NO and (t3.BALANCE>=50 or t2.balance!=t3.BALANCE) ) a原创 2015-10-14 15:08:13 · 308 阅读 · 0 评论 -
SQL杂集
select t3.TX_DATE, t3.pay_type ,t4.DISCOUNT_TYPE ,t3.CARD_TYPE_ID,sum(money_consume) amount from( SELECT t1.* ,t2.CARD_TYPE_ID FROM tjyx.TRANSACTION t1 LEFT JOIN tjyx.member_card t2 ON t2.原创 2015-09-11 16:03:24 · 329 阅读 · 0 评论 -
sql server关于left join的记录
现有approve和projectReg两张表,没有物理外键。approve: businessCode, typeprojectReg: projectIdselect * from projectReg a LEFT JOIN approve b on a.projectRegId = b.businessCodeselect *from approve a LEFT原创 2016-04-08 10:30:40 · 728 阅读 · 0 评论 -
sql server 奇葩问题
SELECT DISTINCT a.*FROM employeeInfo aLEFT JOIN ( SELECT b.buiness FROM quaData b, qualificationsInfo c WHERE b.qualificationsInfoId = c.qualificationsInfoId AND c.qfType = 1 AND c.st原创 2016-05-11 13:48:30 · 420 阅读 · 0 评论