Generated Columns AVG of other columns

[James Butler]

Trying to define simple table with a generated column that contains an average of the other columns, but getting "Invalid use of group function"

TIA for any assistance.

mysql> create table scores (
-> id int,
-> c1 float(4) default 0.1,
-> c2 float(4) default 0.3,
-> c3 float(4) default 0.5,
-> score float(4) generated always as (avg(c1+c2+c3))
-> );
ERROR 1111 (HY000): Invalid use of group function