mysql> USE school;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW TABLES;
+------------------+
| Tables_in_school |
+------------------+
| class |
| sc |
| student |
+------------------+
3 rows in set (0.00 sec)
mysql> SELECT * FROM student;
+-----------+-----------+------+------------------+---------------------+---------------------+
| Sid | Sname | sex | hobby | admission_time | Graduation_time |
+-----------+-----------+------+------------------+---------------------+---------------------+
| 160151210 | 马冬梅 | 女 | 足球,羽毛球 | 2011-09-01 00:00:00 | 2014-06-30 00:00:00 |
| 180112110 | 张三 | 男 | 篮球,足球 | 2008-09-01 00:00:00 | 2011-06-30 00:00:00 |
| 190121250 | 李四 | 男 | 羽毛球 | 2009-09-01 00:00:00 | 2012-06-30 00:00:00 |
+-----------+-----------+------+------------------+---------------------+---------------------+
3 rows in set (0.00 sec)
mysql> DESC student;
+-----------------+------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------------------------------------+------+-----+---------+-------+
| Sid | int(11) | NO | PRI | NULL | |
| Sname | varchar(20) | NO | | NULL | |
| sex | enum('男','女') | YES | | 男 | |
| hobby | set('篮球','足球','兵乓球','羽毛球') | YES | | NULL | |
| admission_time | datetime | NO | | NULL | |
| Graduation_time | datetime | YES | | NULL | |
+-----------------+------------------------------------------------+------+-----+---------+-------+
6 rows in set (0.00 sec)
mysql> INSERT INTO student VALUES(170162125,'张一三','男','篮球','2018-9-30','2021-6-30');
Query OK, 1 row affected (0.02 sec)
mysql> INSERT INTO student VALUES(201421350,'迪丽热巴','女','羽毛球,乒乓球','2015-9-1','2018-6-30');
ERROR 1265 (01000): Data truncated for column 'hobby' at row 1
mysql>
Data truncated for column 'hobby' at row 1
我这个报错是怎么回事。。
已解决，是hobby中的兵乓球打成了“兵”乓球，插入记录时又写成了“乒乓球”，字段不一致导致的错误