37355
$update = Yii::app()->db->createCommand()->update('User',
array('LogTimes' =>new Expression('COALESCE("LogTimes",0)+1'), 'LastLogDT'=>new CDbExpression('NOW()'), 'LastLogIP'=>$loginIp),
"ID=".$userId
);函数COALESCE 是防止字段值一开始为null时候的处理- 37355 2016-08-01 已签到连续签到1天，获得了5个金钱
