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 vote202 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote255 views1 answer
Authentication modes in sql server
SQL
2 votes189 views2 answers
Run mysql command from bash
SQL
0 vote205 views1 answer
Date 3 months from today sql
SQL
0 vote218 views1 answer
Sql date with year
SQL
17 votes183 views6 answers
Mysql import sql file
SQL
6 votes183 views3 answers
Oracle all dates between two dates
SQL
0 vote196 views1 answer
WHERE not regex in SQL
SQL
1 vote176 views1 answer
Mysql login console
SQL
1 vote275 views1 answer
Sql server read uncommitted
SQL