执行

update mkt_order
SET `statement` = 466
WHERE
	`tradesn` IN (
		'201909251849095d8b462dd7f69',
		'201909251850095d8b46693b812',
		'201909251846095d8b45941d0d8',
		'201909251905095d8b4a0543c56',
		'201909261132095d8c3162f379a',
		'201909261132095d8c3162f3848',
		'201909261756095d8c8b67ae0d6',
		'201909261756095d8c8b67ae13d',
		'201909261824095d8c91f236063',
		'201909261824095d8c91f2360c5',
		'201909261824095d8c91f236132',
		'201909291743095d907cdea9c2f',
		'201909291743095d907cdea9c9a',
		'201910022200105d94ad7b9bab6',
		'201910022200105d94ad7b9bbd2'
	)

结果下

[SQL]update mkt_order
SET `statement` = 466
WHERE
	`tradesn` IN (
		'201909251849095d8b462dd7f69',
		'201909251850095d8b46693b812',
		'201909251846095d8b45941d0d8',
		'201909251905095d8b4a0543c56',
		'201909261132095d8c3162f379a',
		'201909261132095d8c3162f3848',
		'201909261756095d8c8b67ae0d6',
		'201909261756095d8c8b67ae13d',
		'201909261824095d8c91f236063',
		'201909261824095d8c91f2360c5',
		'201909261824095d8c91f236132',
		'201909291743095d907cdea9c2f',
		'201909291743095d907cdea9c9a',
		'201910022200105d94ad7b9bab6',
		'201910022200105d94ad7b9bbd2'
	)

受影响的行: 0
时间: 0.006s

更新0行，意味着更新失败

把466改成1  更新成功 然后改会466 更新成功但是statement的值为127

原来将该设成了tinyint类型忘了修改数据类型