我正在尝试使用以下查询更新表:
UPDATE test.t1
SET obrigatorios = (SELECT quantidade FROM test.tcur WHERE tipo = 3)
WHERE perfil IN (7, 11);
或者这个查询应该做同样的事情:
UPDATE test.t1 a, test.tcur b
SET a.obrigatorios = b.quantidade
WHERE a.perfil IN (7, 11)
AND b.tipo = 3;
表tcur的结构如下:
CREATE TABLE `tcur` (\
`quantidade` int(1
变量: n = 378282246310005
m = n
i = 1
sum1 = 0
sum2 = 0
sum11 = 0 我想把下面的c-code转换成python-code: for (m = n, i = 1; m != 0; m = m / 10, i++)
{
r = m % 10;
if (i % 2 != 0)
{
sum1 += r;
}
else
{
sum2 += r * 2;
}
wh
我想做的是
select
"wise, wisdom and wiseness have a common root" as body,
regexp_replace(body,'wis%','wise')
获得
wise --> wise
wisdom --> wise
wiseness --> wise
因此,其结果将是“智慧、智慧和智慧有共同的根源”。