[RESOLVED] Defining field's default value as a SQL function call

Howza,

I'm trying to get a SQL server script working in mySQL.

mySQL does not like one element of the syntax, the issue appears to be using afunction call (such as CURDATE()) as the default value for a field, in the table definition syntax.

Is there a correct syntax for this, or does mysql not support this

Example:

Code:

---

create table tablename (
 ...
 fieldname datetime not null default(curdate())
 ...
);

---

Cheers
- P

Got it (in this case anyway)

Code:

---

fieldname timestamp

---

DId not google hard enough...