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

12 votes198 views4 answers
Import mysql database command line linux
SQL
2 votes243 views1 answer
Coalesce sql
SQL
0 vote206 views1 answer
Mysql master slave setup with keepalived
SQL
5 votes212 views4 answers
Select random rows sql
SQL
7 votes184 views1 answer
Forge server hosting
SQL
0 vote205 views1 answer
How to use query in nosql
SQL
-2 votes217 views1 answer
No module named '_sqlite3
SQL
1 vote220 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote251 views2 answers
Check if sql temp table exists
SQL
2 votes215 views1 answer
Where clause for child record apex
SQL