select @@sql_mode;
CREATE TABLE `t` (
`name` varchar(20),
`email` varchar(40)
);
desc t;
set session sql_mode="REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI";
insert into t(`name`, `email`) values("12345678901234567890999999", "beijing2008@126.com");
set session sql_mode="STRICT_TRANS_TABLES";
Mysql Sql mode test
最新推荐文章于 2024-04-07 17:53:13 发布