MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (
  id INT, 
  val1 INT AS (id + 1),
  val2 INT AS (id * 2) INVISIBLE
);
INSERT INTO test (id) VALUES (1), (11);

Records: 2  Duplicates: 0  Warnings: 0


SELECT *
  FROM test;
SELECT id, val1, val2 
FROM test;


id
val1


1
2

11
12




id
val1
val2


1
2
2

11
12
22


SELECT COLUMN_NAME, EXTRA
  FROM INFORMATION_SCHEMA.COLUMNS
  WHERE TABLE_SCHEMA = DATABASE()
    AND TABLE_NAME = 'test'
  ORDER BY ORDINAL_POSITION;


COLUMN_NAME
EXTRA


id


val1
VIRTUAL GENERATED

val2
VIRTUAL GENERATED INVISIBLE