Mysql virtual column

CREATE TABLE T1 (
    ID          NUMBER,
    PRODUCT     VARCHAR2(50),
    PRICE       NUMBER(10, 2),
    TAXED_PRICE NUMBER(10, 2) GENERATED ALWAYS AS (round(PRICE * 1.2, 2)) VIRTUAL
);
INSERT INTO T1 (ID, PRODUCT, PRICE) VALUES (1, 'Spoon', 12);

Similar codes

1 vote172 views1 answer
Declare variables sql
SQL
0 vote184 views1 answer
Tsql find procedure with name
SQL
-1 vote172 views1 answer
Mysql extract days
SQL
0 vote166 views1 answer
C# datetime to sql server datetime
SQL
1 vote171 views1 answer
Python clean sql string
SQL
0 vote164 views1 answer
Save single sql query result boolean spring boot
SQL
23 votes166 views6 answers
Delete all rows from table sql
SQL
5 votes161 views6 answers
Sql add days to date
SQL
3 votes180 views1 answer
Sql print all names that start with a given letter
SQL
11 votes152 views2 answers
Having clause
SQL