sql语句

插入一列

ALTER TABLE `credits_balance_history`
ADD COLUMN `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '类型（0=>兑换，1=>抽奖，2=>后台充值，3=>自助充值,4=>退单）',

 

select ID,case IS_VALID when 1 then '成功' else '不成功' end is_d,IF(OTHER_USER_ID is NULL,'一级','二级') as userLevel,	DATE_FORMAT(CREATE_DATE,"%Y-%m-%d") from tb_user where CREATE_DATE<=date_format(now(),"%Y-%m-%d") limit 0,10