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 |