check(col
1、问题描述
前两天在群里看到同事反馈一个空格问题，大致现象如下：
mysql> select @@version;+-----------+| @@version |+-----------+| 8.0.25 |+-----------+1 row in set (0.00 sec)mysql> create table t1( -> c1 int, -> c2 varchar(4) check(c2<>'') #单引号之间无空格 -> )engine=innodb;Query OK, 0 rows affected (0.21 sec)mysql> insert into t1 select 1,' '; #c2字段插入两个空格ERROR 3819 (HY000): Check constraint 't1_chk_1' is violated.
