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 vote388 views2 answers
Import data from excel to sql server automatically
SQL
4 votes360 views2 answers
Sql offset
SQL
-2 votes365 views1 answer
No module named '_sqlite3
SQL
0 vote325 views1 answer
Oracle sql date summer time
SQL
0 vote363 views1 answer
Convert int to varchar sql
SQL
0 vote337 views1 answer
Convert sql server guid to varbinary
SQL
32 votes372 views6 answers
Sql count where
SQL
0 vote347 views2 answers
Nested query
SQL
8 votes354 views2 answers
Python simple connect to mysql
SQL
0 vote362 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL