关于更新数据中一个非常奇怪的问题。
我的数据表里面定义了若干字段的类型都是float,但以下面一条数据更新数据时:
MatchInfo set pan=0.5,asia_odds=0.8,euro_win_odds=1.3,euro_draw_odds=3.3,euro_lost_odds=5.3
where match_date='2003-05-10' and home_team_id=101 and away_team_id=102
结果查看数据库
发现 pan=0.5 asia_odds=0.80000000000000004 euro_win_odds=1.3 euro_draw_odds=3.3000000000000001 euro_lost_odds=5.2999999999999998
为什么 aisa_odds, euro_draw_odds,euro_lost_odds会出现以上的现象呢?应该怎样解决?