MySql插入数据类型date

book表描述：

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| book_id     | int          | NO   | PRI | NULL    |       |
| title       | varchar(128) | YES  |     | NULL    |       |
| description | varchar(512) | YES  |     | NULL    |       |
| published   | date         | YES  |     | NULL    |       |
| author_id   | int          | YES  | MUL | NULL    |       |
| price       | float        | YES  |     | NULL    |       |
| rating      | int          | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+

插入date数据类型错误示范：

insert into book values(7,'Thinking in java','Teach you core java in depth',2012-09-12,13,39,5);

插入date数据类型正确示范：

insert into book values(7,'Thinking in java','Teach you core java in depth',20120912,13,39,5);

总结：
插入date数据类型应该插入数字字符串，不应该插入格式符号-