Create Table With Now() Column

[Gatsu]

I use this which I copied from your example with few edits to fit my purposes:

CREATE TABLE tickets(id int NOT NULL auto_increment,ticket int NOT NULL,timea datetime NOT NULL DEAFULT NOW(),PRIMARY KEY (id))

I get thise error:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEAFULT NOW(), PRIMARY KEY (id) )' at line 5CREATE TABLE tickets(id int NOT NULL AUTO_INCREMENT ,ticket int NOT NULL ,timea datetime NOT NULL DEAFULTNOW( ) ,PRIMARY KEY ( id ))Why?

[Synook]

You can't use functions as DEFAULT values^[1].