CREATE TRIGGER set_created_date
BEFORE INSERT ON product
FOR EACH ROW BEGIN
SET NEW.created_date = now();

CREATE TABLE mytable
(
created_date datetime NOT NULL DEFAULT NOW()
)