FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupmysql @
categoriesmysql
postedApr 12, '08 at 3:57a
activeApr 12, '08 at 3:57a
posts1
users1
websitemysql.com
irc#mysql

1 user in discussion

Wang shuming: 1 post

People

Translate

site design / logo © 2021 Grokbase