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 vote232 views1 answer
How to get parent and child record in single query using sql
SQL
7 votes207 views1 answer
Mysql iif
SQL
0 vote187 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
1 vote198 views1 answer
Reutrn string after character sql
SQL
0 vote217 views1 answer
Time mysql w3
SQL
11 votes208 views3 answers
How to get last row of table in sql
SQL
0 vote212 views1 answer
Create database like
SQL
0 vote212 views1 answer
Sqlserver now
SQL
4 votes190 views3 answers
Order by value mysql
SQL
1 vote279 views1 answer
Mysql show database size in mb
SQL