bx75Lpf6

1CREATE TABLE IF NOT EXISTS test (
2    `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
3);
4	
5Error 1067: Invalid default value for 'create_time'
6	
7create trigger bi_mytable
8before insert on mytable 
9for each row 
10begin
11    NEW.create_time = NOW();
12end;
13	
14create trigger bu_mytable
15before update on mytable 
16for each row 
17begin
18    NEW.create_time = OLD.create_time;
19end;