DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a , b GENERATED ALWAYS AS (a+1)) ENGINE= ; SHOW COLUMNS IN t1; Field Type Null Key Default Extra a int(11) # # b int(11) # # VIRTUAL GENERATED INSERT INTO t1 (a) VALUES (1),(2); INSERT INTO t1 (a,b) VALUES (3,3),(4,4); Warnings: Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored SELECT a,b FROM t1; a b 1 2 2 3 3 4 4 5 DROP TABLE t1; CREATE TABLE t1 (a , b GENERATED ALWAYS AS (a+1) PERSISTENT) ENGINE= ; SHOW COLUMNS IN t1; Field Type Null Key Default Extra a int(11) # # b int(11) # # STORED GENERATED INSERT INTO t1 (a) VALUES (1),(2); INSERT INTO t1 (a,b) VALUES (3,3),(4,4); Warnings: Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored SELECT a,b FROM t1; a b 1 2 2 3 3 4 4 5 DROP TABLE t1; CREATE TABLE t1 (a , b GENERATED ALWAYS AS (a+1) VIRTUAL) ENGINE= ; SHOW COLUMNS IN t1; Field Type Null Key Default Extra a int(11) # # b int(11) # # VIRTUAL GENERATED INSERT INTO t1 (a) VALUES (1),(2); INSERT INTO t1 (a,b) VALUES (3,3),(4,4); Warnings: Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored SELECT a,b FROM t1; a b 1 2 2 3 3 4 4 5 DROP TABLE t1; CREATE TABLE t1 (a , b AS (a+1) PERSISTENT) ENGINE= ; SHOW COLUMNS IN t1; Field Type Null Key Default Extra a int(11) # # b int(11) # # STORED GENERATED INSERT INTO t1 (a) VALUES (1),(2); INSERT INTO t1 (a,b) VALUES (3,3),(4,4); Warnings: Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored Warning 1906 The value specified for generated column 'b' in table 't1' has been ignored SELECT a,b FROM t1; a b 1 2 2 3 3 4 4 5 DROP TABLE t1;