Posted by J.O. Aho on 12/13/06 12:41

ulyx wrote:
> Thank you for your time and help.
> I have read links that u have posted and tryed this:
>
> CREATE TABLE `ae_gallery` (
> `id` int(11) NOT NULL auto_increment,
> `title` varchar(64) character set utf8 NOT NULL,
> `ext` varchar(8) character set utf8 NOT NULL,
> `image_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
> ON UPDATE CURRENT_TIMESTAMP,
> `data` mediumblob NOT NULL,
> PRIMARY KEY (`id`)
> );
>
> and i get the same error ( i get just #1064 and text description ).

And the text description was what? My mind reading is a bit broken today.


> If i remove DEFAULT CURRENT_TIMESTAMP
> ON UPDATE CURRENT_TIMESTAMP
> everything is working perfect.
>
> How to add/change this field manualy ?

Use ALTER, see how to use it at
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html


--

//Aho

[Back to original message]