Question

求SQL判断赋值语句

Answer 1

select
CASE WHEN fieldName1='999' THEN '0'
WHEN fieldName1='888' THEN '1'
ELSE fieldName1 END from talbeName;

Answer 2

select t.csname from ysc t where t.id=文本框内的值