Page 1 of 1

TIMESTAMP DEFAULT VALUE

Posted: Fri 19 Jan 2007 02:10
by mgalvan
I'm running MySQL Developer Studio 1.51.33. When I treat to edit a table adding a new column, I get an error message: Invalid default value for 'my_TIMESTAMP_fieldname'. I have in my table a TIMESTAMP column with default value = CURRENT_TIMESTAMP. Pleace Help!

Posted: Mon 22 Jan 2007 15:01
by Duke
We are working over the problem with CURRENT_TIMESTAMP. By now, you should manually add column to the such table (with ALTER TABLE ... ADD COLUMN).