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

2 votes317 views2 answers
Calculate percentage in sql
SQL
0 vote297 views2 answers
Sqlite unique
SQL
12 votes296 views2 answers
Delete all nodes neo4j
SQL
3 votes288 views1 answer
Oracle undo tablespace list by user
SQL
2 votes363 views1 answer
Tcl in sql
SQL
10 votes361 views4 answers
Join multiple tables in sql
SQL
1 vote302 views2 answers
Datetrunc hour snowflake
SQL
23 votes306 views1 answer
How remove column in mysql
SQL
3 votes299 views3 answers
Update join
SQL
0 vote325 views1 answer
Sql quary stuf
SQL