mysql insert中用case

insert into urls(company,counterType,mdUrl,tradeUrl) values('test',

CASE 'test'
WHEN 'CTP' THEN 1
WHEN 'NULL' THEN 2
WHEN '飞鼠' THEN 3
WHEN '飞鼠 FIX' THEN 4
WHEN 'CTP FIX' THEN 5
WHEN 'QuantHub' THEN 6
ELSE 0
END
,'mdurl','tradeurl')

感觉这样做没什么意义。

转载于:https://www.cnblogs.com/a9999/p/6248664.html