子查询然后给个别名就好了
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 |
| jiuzheP | $1,200.00 | Mar 24 | 13:03:32 |
| jiuzheP | $1,150.00 | Mar 24 | 13:01:34 |
| Alibackorders | $1,100.00 | Mar 24 | 13:01:34 |
| jiuzheP | $1,050.00 | Mar 24 | 13:01:04 |
| AlibackordersP | $1,000.00 | Mar 24 | 13:01:04 |
| Alibackorders | $950.00 | Mar 24 | 13:00:28 |
| jiuzheP | $900.00 | Mar 24 | 12:59:50 |
| Alibackorders | $850.00 | Mar 24 | 12:59:50 |
| jiuzheP | $800.00 | Mar 24 | 12:58:42 |
| Alibackorders | $750.00 | Mar 24 | 12:58:42 |
| jiuzheP | $700.00 | Mar 24 | 12:58:11 |
| Alibackorders | $650.00 | Mar 24 | 12:58:11 |
| jiuzheP | $600.00 | Mar 24 | 12:55:03 |
| zhangshuxi | $550.00 | Mar 24 | 10:16:17 |
| AlibackordersP | $500.00 | Mar 24 | 10:16:11 |
| zhangshuxi | $500.00 | Mar 24 | 10:16:11 |
| AlibackordersP | $480.00 | Mar 24 | 10:14:06 |
| nameword | $460.00 | Mar 24 | 10:14:06 |
| AlibackordersP | $440.00 | Mar 24 | 07:42:46 |
| hubaba | $420.00 | Mar 24 | 07:16:55 |
| AlibackordersP | $400.00 | Mar 24 | 07:16:48 |
| hubaba | $400.00 | Mar 24 | 07:16:48 |
| AlibackordersP | $240.00 | Mar 24 | 07:01:43 |
| hubaba | $220.00 | Mar 24 | 06:59:38 |
| AlibackordersP | $200.00 | Mar 24 | 05:48:17 |
| tttian | $200.00 | Mar 24 | 05:48:17 |
| AlibackordersP | $145.00 | Mar 24 | 05:47:54 |
| tttian | $135.00 | Mar 24 | 05:47:54 |
| AlibackordersP | $114.00 | Mar 23 | 22:24:59 |
| ffound | $104.00 | Mar 23 | 21:43:14 |
| nameword | $99.00 | Mar 23 | 19:01:08 |
| Alibackorders | $94.00 | Mar 23 | 02:22:54 |
| nameword | $89.00 | Mar 22 | 20:37:06 |
| bosskk | $84.00 | Mar 22 | 13:50:54 |
| hubaba | $79.00 | Mar 22 | 07:30:40 |
| AlibackordersP | $74.00 | Mar 21 | 20:41:39 |
| dozieo | $74.00 | Mar 21 | 20:41:39 |
| Alibackorders | $69.00 | Mar 21 | 18:06:20 |
| chinasoa | $64.00 | Mar 21 | 14:32:26 |
| tttian | $59.00 | Mar 17 | 18:24:42 |
| Alibackorders | $59.00 | Mar 18 | 01:01:07 |
| danny9 | $59.00 | Mar 21 | 05:33:56 |
| jiuzhe | $59.00 | Mar 21 | 05:38:47 |
| first1 | $59.00 | Mar 21 | 08:02:02 |
| nameword | $59.00 | Mar 21 | 08:34:03 |
| DefendOr6 | $59.00 | Mar 21 | 09:26:03 |
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函数保证了肯定有一行记录，但是可能是null
ifnull再进一步转换一个默认值或异常值
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.00 | Mar 20 | 12:54:47 |
| first1 | $2,401.00 | Mar 20 | 12:54:47 |
| jackiesjkP | $2,351.00 | Mar 20 | 12:33:38 |
| first1 | $2,301.00 | Mar 20 | 12:33:38 |
| jackiesjkP | $2,251.00 | Mar 20 | 10:07:49 |
| first1 | $2,201.00 | Mar 20 | 10:07:49 |
| jackiesjkP | $2,151.00 | Mar 20 | 10:01:57 |
| first1 | $2,101.00 | Mar 20 | 10:01:57 |
| jackiesjk | $2,051.00 | Mar 20 | 08:56:02 |
| AlibackordersP | $2,001.00 | Mar 20 | 08:55:41 |
| jackiesjk | $2,000.00 | Mar 20 | 08:55:41 |
| AlibackordersP | $1,250.00 | Mar 20 | 08:55:23 |
| jackiesjk | $1,200.00 | Mar 20 | 08:55:23 |
| AlibackordersP | $709.00 | Mar 20 | 08:55:04 |
| jackiesjk | $659.00 | Mar 20 | 08:55:04 |
| Alibackorders | $609.00 | Mar 20 | 06:58:24 |
| chinasoa | $559.00 | Mar 20 | 06:14:33 |
| first1 | $509.00 | Mar 20 | 05:03:36 |
| chinasoaP | $499.00 | Mar 20 | 04:51:52 |
| chinasoaP | $489.00 | Mar 20 | 04:54:05 |
| first1 | $469.00 | Mar 20 | 04:54:05 |
| chinasoa | $449.00 | Mar 20 | 04:51:52 |
| first1 | $429.00 | Mar 19 | 20:09:51 |
| EastRiver | $409.00 | Mar 19 | 12:50:53 |
| first1 | $389.00 | Mar 19 | 12:25:56 |
| DefendOr6P | $369.00 | Mar 19 | 09:37:36 |
| first1 | $369.00 | Mar 19 | 09:37:36 |
| DefendOr6P | $349.00 | Mar 19 | 09:32:38 |
| first1 | $329.00 | Mar 19 | 09:32:38 |
| DefendOr6 | $309.00 | Mar 19 | 09:28:34 |
| first1 | $289.00 | Mar 19 | 03:09:36 |
| SanPinDai | $269.00 | Mar 19 | 03:09:25 |
| first1 | $249.00 | Mar 18 | 19:48:02 |
| imlihoc | $229.00 | Mar 18 | 18:42:27 |
| first1 | $209.00 | Mar 18 | 12:18:39 |
| dgdgdgggP | $199.00 | Mar 18 | 12:13:42 |
| first1 | $194.00 | Mar 18 | 12:13:42 |
| dgdgdgggP | $184.00 | Mar 18 | 12:09:05 |
| first1 | $174.00 | Mar 18 | 12:09:05 |
| dgdgdgggP | $164.00 | Mar 18 | 12:04:32 |
| first1 | $154.00 | Mar 18 | 12:04:32 |
| dgdgdgggP | $144.00 | Mar 18 | 11:59:33 |
| first1 | $134.00 | Mar 18 | 11:59:33 |
| dgdgdgggP | $124.00 | Mar 18 | 11:55:17 |
| first1 | $114.00 | Mar 18 | 11:55:17 |
| dgdgdgggP | $104.00 | Mar 18 | 11:50:45 |
| first1 | $99.00 | Mar 18 | 11:50:45 |
| dgdgdggg | $94.00 | Mar 18 | 11:49:34 |
| first1 | $89.00 | Mar 18 | 09:08:36 |
| zhuhewsc | $84.00 | Mar 18 | 09:03:09 |
| first1 | $79.00 | Mar 18 | 02:20:53 |
| hubaba | $74.00 | Mar 17 | 17:50:17 |
| luxtea | $69.00 | Mar 17 | 13:33:27 |
| chinasoa | $64.00 | Mar 17 | 13:27:15 |
| tttian | $59.00 | Mar 13 | 05:25:35 |
| jiuzhe | $59.00 | Mar 13 | 14:31:04 |
| witcat | $59.00 | Mar 14 | 01:23:44 |
| Alibackorders | $59.00 | Mar 14 | 05:10:05 |
| first1 | $59.00 | Mar 17 | 08:01:03 |
| DefendOr6 | $59.00 | Mar 17 | 09:26:06 |
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 16 | 12:51:17 |
| encgtheltg | $900.00 | Mar 16 | 12:51:17 |
| AlibackordersP | $850.00 | Mar 16 | 11:33:00 |
| AlibackordersP | $651.00 | Mar 16 | 12:16:35 |
| encgtheltg | $601.00 | Mar 16 | 12:16:35 |
| Alibackorders | $550.00 | Mar 16 | 11:33:00 |
| first1 | $500.00 | Mar 16 | 05:30:32 |
| huoxing | $480.00 | Mar 15 | 23:07:52 |
| jiuzhe | $460.00 | Mar 15 | 19:40:27 |
| boomin | $440.00 | Mar 15 | 08:41:36 |
| ggggggggg | $420.00 | Mar 15 | 04:17:26 |
| mani0307P | $400.00 | Mar 14 | 13:15:51 |
| SanPinDai | $399.00 | Mar 14 | 13:15:51 |
| mani0307P | $379.00 | Mar 14 | 07:50:31 |
| haeinstone | $359.00 | Mar 14 | 07:50:31 |
| mani0307 | $339.00 | Mar 14 | 06:44:01 |
| AlibackordersP | $333.00 | Mar 13 | 23:42:47 |
| Alibackorders | $319.00 | Mar 13 | 23:42:47 |
| Takes2ToTangoP | $299.00 | Mar 13 | 15:35:46 |
| Takes2ToTangoP | $89.00 | Mar 13 | 20:59:45 |
| iamsky | $84.00 | Mar 13 | 20:59:45 |
| Takes2ToTangoP | $79.00 | Mar 13 | 16:54:58 |
| CatchTheDrop | $74.00 | Mar 13 | 16:54:58 |
| Takes2ToTango | $69.00 | Mar 13 | 15:35:46 |
| ronchy | $64.00 | Mar 13 | 14:45:16 |
| mani0307 | $59.00 | Mar 9 | 10:44:21 |
| Alibackorders | $59.00 | Mar 10 | 23:07:03 |
| Aliases | $59.00 | Mar 12 | 05:12:15 |
| first1 | $59.00 | Mar 12 | 08:01:03 |
| nameword | $59.00 | Mar 12 | 08:34:16 |
| belgravia | $59.00 | Mar 12 | 14:04:14 |
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:04 PST | $1,511.00 | Bid Placed |
| juming | 01-Mar-2019 12:04 PST | $1,461.00 | Bid Placed |
| 9ten | 01-Mar-2019 12:04 PST | $1,411.00 | Bid Placed |
| juming | 01-Mar-2019 12:00 PST | $1,361.00 | Bid Placed |
| istu | 01-Mar-2019 11:53 PST | $1,311.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:53 PST | $1,261.00 | Bid Placed |
| istu | 01-Mar-2019 11:53 PST | $1,261.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:49 PST | $1,211.00 | Bid Placed |
| juming | 01-Mar-2019 11:42 PST | $1,161.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:35 PST | $1,111.00 | Bid Placed |
| juming | 01-Mar-2019 11:35 PST | $1,105.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:27 PST | $1,055.00 | Bid Placed |
| juming | 01-Mar-2019 11:27 PST | $1,005.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:20 PST | $980.00 | Bid Placed |
| juming | 01-Mar-2019 11:20 PST | $955.00 | Bid Placed |
| 9ten | 01-Mar-2019 11:14 PST | $930.00 | Bid Placed |
| juming | 01-Mar-2019 11:14 PST | $905.00 | Bid Placed |
| 9ten | 01-Mar-2019 10:37 PST | $880.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 10:37 PST | $855.00 | Bid Placed |
| 9ten | 01-Mar-2019 10:31 PST | $830.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 09:18 PST | $805.00 | Bid Placed |
| 9ten | 01-Mar-2019 09:18 PST | $800.00 | Bid Placed |
| 9ten | 01-Mar-2019 09:17 PST | $780.00 | Bid Placed |
| juming | 01-Mar-2019 09:17 PST | $755.00 | Bid Placed |
| 9ten | 01-Mar-2019 07:01 PST | $730.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 07:01 PST | $705.00 | Bid Placed |
| 9ten | 01-Mar-2019 07:00 PST | $680.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 07:00 PST | $655.00 | Bid Placed |
| 9ten | 01-Mar-2019 06:59 PST | $630.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 06:59 PST | $605.00 | Bid Placed |
| 9ten | 01-Mar-2019 06:55 PST | $580.00 | Bid Placed |
| www22cn-1 | 01-Mar-2019 06:55 PST | $555.00 | Bid Placed |
| 9ten | 27-Feb-2019 11:15 PST | $530.00 | Bid Placed |
| aliyun | 27-Feb-2019 11:15 PST | $505.00 | Bid Placed |
| aliyun | 26-Feb-2019 23:41 PST | $130.00 | Bid Placed |
| juming | 26-Feb-2019 23:41 PST | $125.00 | Bid Placed |
| aliyun | 26-Feb-2019 22:26 PST | $115.00 | Bid Placed |
| justdropped1 | 26-Feb-2019 22:26 PST | $110.00 | Bid Placed |
| justdropped1 | 26-Feb-2019 17:06 PST | $86.00 | Bid Placed |
| nj–liaohaiyin | 26-Feb-2019 17:06 PST | $85.00 | Bid Placed |
| justdropped1 | 26-Feb-2019 12:39 PST | $83.00 | Initial Bid |
| mahaeinstone | 26-Feb-2019 12:39 PST | $82.00 | Initial Bid |
| domspace | 26-Feb-2019 12:39 PST | $81.00 | Initial Bid |
| istu | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| lbren | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–chiara | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| aliyun | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| hubaba | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| bidalias2 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| 9ten | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| myphoxero | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| rn0412 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–liaohaiyin | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–mehulhathi | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–elderlyjr | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| juming | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–callmemaybe | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| www22cn-1 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| defendor01 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–deeppocket | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| arirangcnt | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–result | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| 537494 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–markmon | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–idevlabs | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–russell | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| nj–thelion | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| rick77 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| mike0007 | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| himalia | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| dominc | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| dribble | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| mesacinza | 26-Feb-2019 12:39 PST | $79.00 | Initial Bid |
| briton leap | 26-Feb-2019 12:39 PST | $60.00 | Initial Bid |
用代码让世界变得更美好一些
2019-01-17 by Jinyang | No Comments | Filed in Uncategorized办理了税务变更
银行账号变更
都比较顺利
但是一天时间还是就这样消耗了
所以半夜起来加班写代码
查看linux系统中全部用户的crontab任务
2019-01-09 by Jinyang | No Comments | Filed in Uncategorized进入目录
/var/spool/cron/crontabs
查看编辑即可
定时重启php7.0-fpm
2019-01-09 by Jinyang | No Comments | Filed in Uncategorized每两小时重启一次：
0 */2 * * * service php7.0-fpm restart
开启crontab日志：
sudo vim /etc/rsyslog.d/50-default.conf cron.* /var/log/cron.log #将cron前面的注释符去掉
