Issues with timestamp query

33 Views Asked by At

I have issues with timestamp query. Please look at below query:

create table captions (
text varchar(150),
created_at timestamp default current_timestamp,
updated_at timestamp on update current_timestamp);

output:

Error Code: 1067. Invalid default value for 'updated_at'

0

There are 0 best solutions below