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 vote191 views1 answer
Oracle pl/sql check if file exists
SQL
8 votes182 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote172 views1 answer
Mysql xampp reset root password
SQL
0 vote255 views1 answer
Store case result sql
SQL
0 vote174 views1 answer
Wordpress sql change site url
SQL
7 votes179 views2 answers
Create mysql user
SQL
-2 votes174 views1 answer
Use of where in left join in mysql
SQL
0 vote176 views1 answer
Delete duplicate rows
SQL
24 votes185 views5 answers
List mysql users
SQL
0 vote277 views1 answer
Multiple replace value mssql
SQL