56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> create table tx (c1 varchar(10));
Query OK, 0 rows affected (0.09 sec)
mysql> insert into tx values ('1234567890');
Query OK, 1 row affected (0.06 sec)
mysql> insert into tx values ('文字文字文字文字文字');
ERROR 1406 (22001): Data too long for column 'c1' at row 1
mysql> insert into tx values ('文字文字文');
Query OK, 1 row affected (0.06 sec)
mysql> show create table tx;
+-------+---------------------------------------
| Table | Create Table
+-------+---------------------------------------
| tx | CREATE TABLE `tx` (
`c1` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+---------------------------------------
1 row in set (0.00 sec)
mysql>