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 vote286 views1 answer
Postgres set column equal to another
SQL
0 vote280 views1 answer
How to use query in nosql
SQL
0 vote274 views2 answers
Postgresql create role
SQL
0 vote327 views1 answer
Bigrock database connection string
SQL
-1 vote297 views1 answer
Concat two columns in sql server
SQL
0 vote282 views1 answer
Connect postgresql using a connection string
SQL
0 vote314 views1 answer
How to create notes in mysql
SQL
0 vote288 views3 answers
Postgresql grant alter table to user
SQL
8 votes340 views2 answers
Default sql server port
SQL
3 votes289 views2 answers
Find the median in sql
SQL