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

0 vote124 views1 answer
Get last run query sql server
SQL
0 vote171 views1 answer
How to delete python anywhere mysql database
SQL
0 vote166 views1 answer
Procedure excute monthly oracle
SQL
0 vote164 views1 answer
Mysql change default collation
SQL
10 votes263 views2 answers
Doublon sql
SQL
0 vote168 views1 answer
How to use query in nosql
SQL
1 vote167 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote171 views1 answer
Add unique constraint sql server multiple columns
SQL
14 votes206 views1 answer
Excel is not a database
SQL
0 vote236 views1 answer
Delet all record statment sql
SQL