By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `deleteme` (
`number` int(11),
`result` int(11) GENERATED ALWAYS AS (`number` + 1) STORED
)
SELECT column_name, generation_expression
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'deleteme'
| COLUMN_NAME | GENERATION_EXPRESSION |
|---|---|
| number | |
| result | (`number` + 1) |