// 这个是mysql批量更新 UPDATE stat_journal t1 SET t1.first_recharge = (SELECT COUNT(*) FROM first_recharge_record frr LEFT JOIN member_info mi ON frr.member_id = mi.id WHERE mi.member_type = ‘0’ AND DATE_FORMAT(frr.recharge_time,’%Y-%m-%d’) = t1.date )
// 批量插入 INSERT INTO stat_stock_0 SELECT * FROM stat_stock WHERE contract_serial_number LIKE ‘%0’;
