" . . " can"t insert into a date field,but update can

" . . " can"t insert into a date field,but update can

am 12.04.2008 05:57:18 von wang shuming

------=_Part_16007_5376300.1207972638729
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,
table table1 int1 int auto_increament ,
date date not null default '0000-00-00'

1) insert into table1 (date) values(' . . ')

// shows Incorrect date value: ' . . ' for column date' at row 1
// ' . . ' ==> space(4)+"."+space(2)+"."+space(2)

2) update table1 set date=' . . '

// this done .

I hope can insert a ' . . ' value to a date field .
Mysql 5.0.51

Regards!

Shuming Wang

------=_Part_16007_5376300.1207972638729--