如果让mysql认20/5/2011这种格式呢？？

我用insert语句插入20/5/2011这种日期格式，date类型的字段显示全是0呢，我应该怎么设置此日期字段，请指教

插入的时候用str_to_date转换成标准的日期格式即可：
mysql> select str_to_date('20/5/2011', '%d/%m/%Y');
+--------------------------------------+
| str_to_date('20/5/2011', '%d/%m/%Y') |
+--------------------------------------+
| 2011-05-20 |
+--------------------------------------+
1 row in set (0.00 sec)

SQL code

mysql> create table datefoo(a date);
Query OK, 0 rows affected (0.13 sec)

mysql> insert into datefoo values(str_to_date('20/5/2011', '%d/%m/%Y'));
Query OK, 1 row affected (0.00 sec)

mysql> select * from datefoo;
+------------+
| a          |
+------------+
| 2011-05-20 |
+------------+
1 row in set (0.00 sec)