598224: daysOfYear=360,
737706: daysOfYear=360,
760428: daysOfYear,
803628: daysOfYear=360,
829346: daysOfYear=360,
830128: daysOfYear=360,
830559: daysOfYear=360,
831028: daysOfYear=360,
831172: daysOfYear=360,
966702: daysOfYear=365,
1659121: daysOfYear,
1661908: daysOfYear,
1663943: daysOfYear=365,
1671486: daysOfYear=365,
use `zjzc`/*!*/;
SET TIMESTAMP=1450238280/*!*/;
update Product set
status = '3'
where status = '2' and buyToTime < '2015-12-16 11:58:00'
#151215 19:38:28 server id 135 end_log_pos 221298448 CRC32 0xe111d0cf Query thread_id=935434 exec_time=0 error_code=0
SET TIMESTAMP=1450179508/*!*/;
update Product set
name = '温金宝系列39期',
productType = 4,
riskLevel = '1',
yield = 0.0600000000,
valueStartDate = '2015-12-17 00:00:00',
valueEndDate = '2016-01-28 00:00:00',
duration = 43,
expirationDate = null,
delegator = 3,
custody = '温州金融资产交易中心股份有限公司',
buyFromTime = '2015-12-15 15:42:00',
buyToTime = '2015-12-17 23:59:59',
entryUnit = 10000,
maxUnit = 10000000,
addUnit = 10000,
recommendDate = '2015-12-18 00:00:00',
status = '2',
assignType = '1',
contractSn = 63,
totalQuota = 10000000,
unitValue = 1.0000000000,
settlementDate = '2016-01-29 00:00:00',
compound ='2',
contract = null,
riskInfo='外部评级AA+或以上的大型国企提供回购流动性支持',
bonus=0.0000000000,
bonusType='0',
accessType=1,
realValueStartDate = '2015-12-17 00:00:00',
realValueEndDate = '2016-01-28 00:00:00',
realSettlementDate = '2016-01-29 00:00:00',
stageNum = 1,
stagingTemplateId = null,
isOnlyForFirst = '1',
financeType = '1',
buyAcctTypes = '1',
naturalSeasonRepaymentDay = null,
wzeCardYieldOnOff = '1',
wzeCardYield = 0.0060000000,
maxClient=196,
maxYield=0.0800000000,
stairYieldSn=17,
publishChannel=3001,
yieldForFirst=0.0000000000,
quotaForFirst=0,
daysOfYear=365,
`precision`=2,
supportCoupon=2,
supportStock=2
where sn = 74
/*!*/;
#151216 10:15:40 server id 135 end_log_pos 244866437 CRC32 0x70376edf Query thread_id=947603 exec_time=0 error_code=0
use `zjzc`/*!*/;
SET TIMESTAMP=1450232140/*!*/;
update Product set
name = '体验宝系列22期',
productType = 4,
riskLevel = '1',
yield = 0.0600000000,
valueStartDate = '2015-12-17 00:00:00',
valueEndDate = '2016-03-16 00:00:00',
duration = 91,
expirationDate = null,
delegator = 3,
custody = '温州金融资产交易中心股份有限公司',
buyFromTime = '2015-12-15 10:12:00',
buyToTime = '2015-12-17 23:59:59',
entryUnit = 10000,
maxUnit = 5000000,
addUnit = 10000,
recommendDate = '2015-12-18 00:00:00',
status = '2',
assignType = '1',
contractSn = 65,
description = '“体验宝”系列22期是浙江爱晚基金管理有限公司为温金中心金融资产交易平台的投资者提供的一款高流动性、较高收益率固定收益产品。本产品属于短期理财产品,产品投资预期综合年化收益率为【6 】%/年加温金宝卡息收益,投资期限预计为91个自然日。',
totalQuota = 5000000,
unitValue = 1.0000000000,
settlementDate = '2016-03-17 00:00:00',
compound ='2',
contract = null,
riskInfo='外部评级AA+或以上的大型国企控股子公司提供本息担保回购',
bonus=0.0000000000,
bonusType='0',
accessType=1,
realValueStartDate = '2015-12-17 00:00:00',
realValueEndDate = '2016-03-16 00:00:00',
realSettlementDate = '2016-03-17 00:00:00',
stageNum = 1,
stagingTemplateId = null,
isOnlyForFirst = '2',
financeType = '1',
buyAcctTypes = '1',
naturalSeasonRepaymentDay = null,
wzeCardYieldOnOff = '1',
wzeCardYield = 0.0080000000,
maxClient=196,
maxYield=0.0800000000,
stairYieldSn=17,
publishChannel=3001,
yieldForFirst=0.0000000000,
quotaForFirst=100000,
daysOfYear=365,
`precision`=2,
supportCoupon=1,
supportStock=2
where sn = 76
#151216 10:24:27 server id 135 end_log_pos 245569467 CRC32 0x475caa08 Query thread_id=947709 exec_time=0 error_code=0
use `zjzc`/*!*/;
SET TIMESTAMP=1450232667/*!*/;
update Product set
name = '体验宝系列21期',
productType = 4,
riskLevel = '1',
yield = 0.0600000000,
valueStartDate = '2015-12-17 00:00:00',
valueEndDate = '2016-01-04 00:00:00',
duration = 19,
expirationDate = null,
delegator = 3,
custody = '温州金融资产交易中心股份有限公司',
buyFromTime = '2015-12-15 10:08:00',
buyToTime = '2015-12-17 23:59:59',
entryUnit = 10000,
maxUnit = 5000000,
addUnit = 10000,
recommendDate = '2015-12-18 00:00:00',
status = '2',
assignType = '1',
contractSn = 64,
description = '“体验宝”系列21期是浙江爱晚基金管理有限公司为温金中心金融资产交易平台的投资者提供的一款高流动性、较高收益率固定收益产品。本产品属于超短期理财产品,产品投资预期综合年化收益率为【6 】%/年加温金宝加息收益,投资期限预计为19个自然日。',
totalQuota = 5000000,
unitValue = 1.0000000000,
settlementDate = '2016-01-05 00:00:00',
compound ='2',
contract = null,
riskInfo='外部评级AA+或以上的大型国企控股子公司提供本息担保回购',
bonus=0.0000000000,
bonusType='0',
accessType=1,
realValueStartDate = '2015-12-17 00:00:00',
realValueEndDate = '2016-01-04 00:00:00',
realSettlementDate = '2016-01-05 00:00:00',
stageNum = 1,
stagingTemplateId = null,
isOnlyForFirst = '1',
financeType = '1',
buyAcctTypes = '1',
naturalSeasonRepaymentDay = null,
wzeCardYieldOnOff = '1',
wzeCardYield = 0.0060000000,
maxClient=196,
maxYield=0.0800000000,
stairYieldSn=16,
publishChannel=3001,
yieldForFirst=0.0140000000,
quotaForFirst=100000,
daysOfYear=365,
`precision`=2,
supportCoupon=2,
supportStock=2
where sn = 75
/*!*/;
mysql binlog 分析
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
上一篇:mysql 排序 /tmp被撑爆
下一篇:Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Not unique table/alias: 'e'
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
【Docker】Dcoker开启MySQL容器binlog日志
Dcoker开启MySQL容器binlog日志
mysql vim 日志文件 -
mysql binlog查看指定数据库
mysql binlog查看指定数据库的方法。
mysql 二进制日志 MySQL -
binlog解析 mysql 开源工具 mysql binlog原理
什么是 MySQL 主从同步当 master(主)库的数据发生变化的时候,变化会实时的同步到slave(从)库。主从同步有什么好处水平扩展数据库的负载能力容错,高可用。Failover/High Availability数据备份主从同步的原理是什么首先我们来了解 master-slave 的体系结构。如下图:不管是 delete、update、insert,还是创建函数、存储过程,所有的操作都在
binlog解析 mysql 开源工具 mysql binlog查看 mysql binlog查看工具 mysql 事件 mysql 查看binlog