load data date fields

[New eba]

Please help me with syntax to load date format data as below.

table
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(10) | YES | | NULL | |
| dte | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+

data file

aaa, 5-Jan-2009
aaa, 5-Feb-2009

what should i do to load this data into mysql table.

i am using below command/syntax but its loading all in this format.

LOAD DATA INFILE '/tmp/ld.txt' INTO TABLE test1 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
(name,@dte)
SET dte = (str_to_date(@dte, '%d-%m-%y');

MySql> select * from test1;
+------+------------+
| name | dte |
+------+------------+
| aaa | 0000-00-00 |
| aaa | 0000-00-00 |


I want date to be in 2008-01-05 format, Please help me.