ALTER TABLE

[Peter Lauri]

Hi,

 

I am doing this thru the phpmyadmin interface:

 

ALTER TABLE doc ALTER docts SET DEFAULT CURRENT_TIMESTAMP

 

However, it returns #1064 - You have an error in your SQL syntax near
'DEFAULTCURRENT_TIMESTAMP' at line 1

 

As you can see the error shows that DEFAULT an CURRENT_TIMESTAMP has been
written together, strange, or is my syntax in the ALTER TABLE wrong?

 

/Peter