隐式转换问题

CREATE TABLE `v` (
  `itov` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

mysql> insert into v values('20180119000133312');
Query OK, 1 row affected (0.06 sec)

mysql> insert into v values('20180119000133313');
Query OK, 1 row affected (0.00 sec)

mysql> insert into v values('20180119000133314');
Query OK, 1 row affected (0.01 sec)


sql_mode      | STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

mysql>  select * from v where itov=20180119000133310;
+-------------------+
| itov              |
+-------------------+
| 20180119000133312 |
| 20180119000133313 |
| 20180119000133314 |
+-------------------+
3 rows in set (0.00 sec)

mysql> select * from v where itov='20180119000133310';
Empty set (0.00 sec)

 

posted on 2018-02-02 11:48  星期六男爵  阅读(114)  评论(0)    收藏  举报

导航