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 vote223 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote224 views1 answer
Mysql root permission denied lost
SQL
1 vote213 views1 answer
How to find median of a column sql
SQL
8 votes218 views2 answers
Alert table name mysql
SQL
0 vote178 views1 answer
How to check oracle index table
SQL
7 votes203 views2 answers
Create index mysql
SQL
0 vote212 views2 answers
Sql server select first day of previous year
SQL
1 vote222 views1 answer
Mysql f# examples
SQL
0 vote232 views1 answer
Drop-toys-table
SQL
1 vote220 views1 answer
Float precision in psql
SQL