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

2 votes191 views1 answer
Oracle find unusable indexes
SQL
0 vote190 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote246 views1 answer
Mysql sort by date column
SQL
1 vote187 views2 answers
Reset mysqli fetch_arra
SQL
0 vote175 views3 answers
Above average salary in sql
SQL
0 vote171 views1 answer
Tsql delete all rows
SQL
0 vote190 views1 answer
Get substract count sql
SQL
0 vote201 views1 answer
View to table sql
SQL
0 vote205 views1 answer
Search column name sql
SQL
0 vote195 views1 answer
Add sqlcmd to path linux
SQL