On 4/9/2012 9:12 PM, YAN HONG YE wrote:
update dzhhq set dzhhq.mlevel=
update dzhhq set mlevel=...
case
dzhhq.stkname=myref.stkname when 1 then 88 else 0
end;
What's myref? Which row of which table is myref.stkname supposed to come
from?
You might be looking for something like
update dzhhq set dzhhq.mlevel=
case
dzhhq.stkname=myref.stkname when 1 then 88 else 0
end;
show error:
Query Error: near ".": syntax error Unable to execute statement
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:
2 matches
Mail list logo
