请教一个关于日期的问题
创建了一个表，插入数据，其中一项是日期，具体不了解日期格式是如何，结果输出为：
mysql> SELECT * FROM plsql01_purchase;
+----------------+---------------+--------------+
| product_name | product_price | product_date |
+----------------+---------------+--------------+
| Product Name 1 | 1.00 | 0005-10-00 |
| Product Name 2 | 2.50 | 0005-10-00 |
| Product Name 3 | 50.75 | 2010-11-01 |
| Product Name 4 | 99.99 | 2031-08-03 |
+----------------+---------------+--------------+
4 rows in set (0.00 sec)
mysql> DESC plsql01_purchase;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| product_name | varchar(25) | YES | | NULL | |
| product_price | double(4,2) | YES | | NULL | |
| product_date | date | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
mysql对日期的输入不会检测吗？出现0号也能插入？？
插入语句为：
mysql> INSERT INTO plsql01_purchase VALUES ('Product Name 2',2.5,'5-10-00'),('Pr
oduct Name 3',50.75,'10-11-01'),('Product Name 4',99.99,'31-8-03');
Query OK, 3 rows affected (0.38 sec)
Records: 3 Duplicates: 0 Warnings: 0
望达人赐教
