DROP TABLE IF EXISTS temp_tianmai;
CREATE TABLE temp_tianmai AS SELECT t.id, t.tianmai_id, t.create_date, (@num:=@num+1) AS order_no FROM t_ss_tianmai_resource t, (SELECT @num:=0) a ORDER BY t.tianmai_id, t.create_date ASC;
UPDATE t_ss_tianmai_resource t INNER JOIN temp_tianmai a SET t.order_no=a.order_no WHERE t.id = a.id;
DROP TABLE IF EXISTS temp_tianmai;