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 vote109 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote97 views1 answer
Java mysql date format
SQL
11 votes103 views2 answers
Having keyword sql
SQL
1 vote98 views1 answer
Mamp mysql path mac
SQL
0 vote106 views1 answer
Mysql find db contarint
SQL
0 vote119 views1 answer
Mysql min value row
SQL
2 votes96 views1 answer
Oracle sql drop column if exists
SQL
0 vote114 views1 answer
Alter check command
SQL
0 vote108 views1 answer
Joins vs includes
SQL
0 vote104 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL