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 vote304 views1 answer
Sql convert unix time to date
SQL
0 vote308 views1 answer
Sqlalchemy one column of two has to be not null
SQL
7 votes310 views2 answers
Where keyword sql
SQL
0 vote315 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote277 views1 answer
Uncomment listen_address=localhost
SQL
5 votes309 views4 answers
Mysql update column with value from another table
SQL
1 vote297 views1 answer
Mysql check table exists
SQL
0 vote284 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote298 views1 answer
Size of all tables in a schema oracle
SQL
0 vote293 views1 answer
What alter does in db
SQL