Error in table creation

I have trying to create a MySQL database table as:

Code:

---

CREATE TABLE `tolltaxsystem1.2`.`vehicle`(
  `vehicle_type` ENUM('LMV','LCV','BUS','TRUCK','MAV') NOT NULL ,
  `vehicle_num` VARCHAR(12) NOT NULL ,
  `journey` ENUM('SJ','CR','EX') NOT NULL ,
  `exempted_type` VARCHAR(4) NOT NULL DEFAULT 'NA' ,
  `material` ENUM('O','ME','MG','AG') NOT NULL DEFAULT 'O' ,
  `amount` DOUBLE(5,2) NOT NULL DEFAULT '0.0' ,
  `booth_num` ENUM('1','2','3','4','5','6','7','8','9') NOT NULL ,
  `lane_num` TINYINT NOT NULL DEFAULT '0' ,
  `passed_at` DATETIME NOT NULL DEFAULT NOW(),
  `image` BLOB
 
 )

---

But it shows me a error that :

Code:

---

Error Code : 1067
Invalid default value for 'passed_at'

---

Please guide me how to remove this error, as i want to store current date and time in the column with every new row insertion with NOW() function..........

Have you read the MySQL documentation?
MySQL :: MySQL 5.6 Reference Manual :: 10.1.4 Data Type Default Values

db

Quote:

---

Have you read the MySQL documentation?
MySQL :: MySQL 5.6 Reference Manual :: 10.1.4 Data Type Default Values

---

Thanks very much..that things are sometimes difficult to explore on web..:)-:

Do me one more favor please, if i want to create a trigger or anything like this that can reset my autoincrement values to zero again with the change in date?
How can i accomplish this?