内充语句

1. set names gbk;
   
2. INSERT INTO pay_info SET
   
3. channelId=(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),
   
4. serverid=1001,
   
5. paynum = (DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),
   
6. paytouser = (select account from octgame.player where chrname='{account}'),
   
7. paygold = {money},
   
8. paymoney=0,
   
9. paytime = now(),
   
10. status = 1,
    
11. ticket = 1,
    
12. chrname='{account}';  

复制代码

1. INSERT INTO pay_info SET channelId=(DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')),serverid=1002,paynum = (DATE_FORMAT(NOW(),'%Y%m%d%H%i%S')) ,paytouser = '{account}',paygold = {money},paymoney=0, paytime = now(), status = 1, ticket = 1

复制代码

感谢楼主 正好需要