各位大佬帮我看下哪里不对
mysql> desc student;
+--------------+-----------------+------+-----+--------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-----------------+------+-----+--------------+-------+
| loginPwd | varchar(20) | NO | | NULL | |
| gradeID | int(4) unsigned | YES | | NULL | |
| phone | varchar(50) | YES | | NULL | |
| address | varchar(255) | YES | | 地址不详 | |
| bornData | datetime | YES | | NULL | |
| email | varchar(50) | YES | | NULL | |
| identityCard | varchar(18) | YES | UNI | NULL | |
| studentName | varchar(8) | NO | | NULL | |
| bornDate | date | YES | | NULL | |
+--------------+-----------------+------+-----+--------------+-------+
9 rows in set (0.00 sec)
mysql> insert into student (loginPwd,studentName,gradeId,phone,bornDate)
-> values (244,'小屁孩',2,13255555555,1994-1-2);
ERROR 1292 (22007): Incorrect date value: '1991' for column 'bornDate' at row 1
mysql> insert into student (loginPwd,studentName,gradeId,phone,bornDate)
-> values (244,'小屁孩',2,13255555555,1994);
ERROR 1292 (22007): Incorrect date value: '1994' for column 'bornDate' at row 1