插入一列
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
转载于:https://www.cnblogs.com/vania/p/6279303.html
