add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table hello(
dob date,
age int as( TIMESTAMPDIFF(YEAR,dob,CURDATE()) ) VIRTUAL
);
create table hello(
dob date,
age int as( TIMESTAMPDIFF(YEAR,dob,CURDATE()) ) PERSISTENT
);
Function or expression 'curdate()' cannot be used in the GENERATED ALWAYS AS clause of `age`