TIMESTAMP DEFAULT VALUE

mgalvan · Post by **mgalvan** » Fri 19 Jan 2007 02:10

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!

Duke · Post by **Duke** » Mon 22 Jan 2007 15:01

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).