ZJU_Main 主页 下一页 ZJU 题型分类 文演整理版 2008-3-23 数论: 1007 Numerical Summation of a Series 简单题,还是蛮有意思的 1045 HangOver 简单题 1049 I Think I Need a Houseboat 简单题 1028 Flip and Shift 简单题,可以DP/BFS/……,但 是实际上有数学方法可直接判断出来 1026 Modular multiplication of polynomials 简单题
[ ERROR ] CAM-CRP-1093 Unable to read the contents of the keystore '/cognos/c8_64/configuration/signkeypair/jCAKeystore'. Reason: java.io.IOException: stream does not represent a PKCS12 key formation
发现问题
最近在处理一些数据库中数据的时候，写了下面的这一条sql语句:
UPDATE f_student
SET school_id = 0
WHERE
id > (
SELECT
id
FROM
f_student
WHERE
school_id = M
LIMIT 1
)
AND id < (
(
SELECT
id
FROM
f_student
WHERE
school_id = M
LIMIT 1
) + N
)
上面的sql是想将某个
报错内容：
1093 – You can’t specify target table ‘t’ for update in FROM clause, Time: 0
前情提示：
Mac OS10.14+MySQL8.0.18；
centOS6.8final+MySQL5.6；
解决：
方法一：多嵌套一层。多来一层子查询
以上SQL修改如下：
UPDATE trace_videorecord SET VideoAddress = 'h8' WHERE VideoID IN
(
SELECT *
