change timestamp to datetime.
have a look in the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DAT
ETIME
-Kim
-Original Message-
From: David Nagel [mailto:[EMAIL PROTECTED]]
Sent: 29. november 2001 21:01
To: [EMAIL PROTECTED]
Subject: Having trouble
I'm having a little trouble with an UPDATE statement in MySQL 3.23.39 on
Mac OS 10.0. The statement is:
UPDATE book SET book_deleted = 'Y' WHERE book_id = '123';
This statement updates the column that I specified and another as well. A
timestamp(14) column is changed to today's date as well.
He
