create table t (a int primary key, b int, c int as (b), index (c)); insert t (a,b) values (10,1); replace delayed t (a,b) values (10,5); check table t; Table Op Msg_type Msg_text test.t check status OK drop table t;