子查询然后给个别名就好了
【阅读全文】
Monthly Archives: 03月 2019
Delete : You can’t specify target table ‘table_name’ for update in FROM clause [duplicate]
2019-03-26 by Jinyang | No Comments | Filed in UncategorizedNiLiao.com Bid History(13 Bidders:, 56 Bids)
2019-03-25 by Jinyang | No Comments | Filed in UncategorizedNiLiao.com Bid History(13 Bidders:, 56 Bids)
Bidder
Bid
Date
Time
jiuzheHigh Bid P
$1,749.00
Mar 24
13:11:54
Alibackorders
$1,699.00
Mar 24
13:11:54
jiuzheP
$1,602.00
Mar 24
13:08:55
Alibackorders
$1,552.00
Mar 24
13:07:37
jiuzheP
$1,550.00
Mar 24
13:07:37
jiuzheP
$1,452.00
Mar 24
13:06:16
Alibackorders
$1,402.00
Mar 24
13:06:16
jiuzheP
$1,301.00
Mar 24
13:04:04
AlibackordersP
$1,251.00
Mar 24
13:04:04
AlibackordersP
$1,250.00
Mar 24
13:03:32
jiu....
【阅读全文】
work from home
2019-03-22 by Jinyang | No Comments | Filed in Uncategorized WFH
在家处理突发工作;
在家更愉快的写代码
【阅读全文】
attempted to return null from a method with a primitive return type (int)
2019-03-21 by Jinyang | No Comments | Filed in Uncategorizedorg.apache.ibatis.binding.BindingException: Mapper method 'cn.Mapper.findCouponIdListByFacadeid attempted to return null from a method with a primitive return type (int). select 语句应该返回一个int字段,但是返回了一个空的结果集,所以代码就报错了,修正方法修改sql语句保证任何时候都返回一个int☞ifnull(sum(字段),0) as 字段 sum函数保证了肯定有一行记录,但是可能是nullifnull再进一步转换一个默认值或异常值
【阅读全文】
Chaohai.com Bid History(15 Bidders:, 72 Bids)
2019-03-21 by Jinyang | No Comments | Filed in Uncategorized
Bidder
Bid
Date
Time
first1High Bid
$3,001.00
Mar 20
13:02:42
jackiesjkP
$3,000.00
Mar 20
13:02:42
jackiesjkP
$2,951.00
Mar 20
12:58:43
first1
$2,901.00
Mar 20
12:58:43
jackiesjkP
$2,851.00
Mar 20
12:57:40
first1
$2,801.00
Mar 20
12:57:40
jackiesjkP
$2,751.00
Mar 20
12:57:06
first1
$2,701.00
Mar 20
12:57:06
jackiesjkP
$2,651.00
Mar 20
12:56:02
first1
$2,601.00
Mar 20
12:56:02
jackiesjkP
$2,551.00
Mar 20
12:55:39
first1
$2,501.00
Mar 20
12:55:39
jackiesjkP
$2,451....
【阅读全文】
TOKEN.CC Bid History(18 Bidders:, 43 Bids)
2019-03-17 by Jinyang | No Comments | Filed in Uncategorized
Bidder
Bid
Date
Time
dcnbusHigh Bid
$1,551.00
Mar 16
13:20:07
jiuzheP
$1,501.00
Mar 16
13:15:24
dcnbus
$1,451.00
Mar 16
13:15:24
jiuzhe
$1,401.00
Mar 16
13:10:37
dcnbus
$1,351.00
Mar 16
13:07:06
jiuzhe
$1,301.00
Mar 16
13:02:29
encgtheltgP
$1,251.00
Mar 16
13:00:02
jiuzhe
$1,250.00
Mar 16
13:00:02
encgtheltgP
$1,200.00
Mar 16
12:59:51
jiuzhe
$1,150.00
Mar 16
12:59:51
encgtheltg
$1,100.00
Mar 16
12:55:16
jiuzhe
$1,050.00
Mar 16
12:54:47
encgtheltgP
$1,002.00
Mar ....
【阅读全文】
Bid history for bailie.com
2019-03-02 by Jinyang | No Comments | Filed in Uncategorized01-Mar-2019 15:23 PST
Bidder
Date
Bid Amount
Comment
9ten
01-Mar-2019 14:12 PST
$1,772.00
Completed
9ten
01-Mar-2019 12:17 PST
$1,772.00
Bid Placed
nj–thelion
01-Mar-2019 12:14 PST
$1,722.00
Bid Placed
dribble
01-Mar-2019 12:14 PST
$1,710.00
Bid Placed
dribble
01-Mar-2019 12:12 PST
$1,661.00
Bid Placed
9ten
01-Mar-2019 12:09 PST
$1,611.00
Bid Placed
istu
01-Mar-2019 12:09 PST
$1,600.00
Bid Placed
istu
01-Mar-2019 12:05 PST
$1,561.00
Bid Placed
9ten
01-Mar-2019 12:....
【阅读全文】