这是复制表的SQL语句:
String sql = "insert into money_old(user_old.userid,user_old.mobile,user_old.cardno,user_old.createtime,user_old.machineid,user_old.username,user_old.usersex,user_old.familyaddress,user_old.deletetime) as select user.userid,user.mobile,user.cardNo,user.createtime,user.machineid,user.username,user.usersex,user.familyadderss,"+DateUtil.getDate()+" from user where cardNo = '"+cardNo+"'";
String sql = "insert into money_old(user_old.userid,user_old.mobile,user_old.cardno,user_old.createtime,user_old.machineid,user_old.username,user_old.usersex,user_old.familyaddress,user_old.deletetime) as select user.userid,user.mobile,user.cardNo,user.createtime,user.machineid,user.username,user.usersex,user.familyadderss,"+DateUtil.getDate()+" from user where cardNo = '"+cardNo+"'";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货