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

22 votes390 views1 answer
Mysql workbench
SQL
2 votes322 views1 answer
Mariadb json select
SQL
0 vote297 views1 answer
Show all mongodb
SQL
7 votes313 views1 answer
Sql server convert string to date
SQL
0 vote322 views1 answer
Ubuntu connect to mssql database
SQL
0 vote448 views1 answer
ORA-01400
SQL
3 votes438 views1 answer
How to get yesterday date in sql
SQL
5 votes303 views1 answer
Ascending order and where in sql
SQL
0 vote332 views1 answer
Pgsql is not permitted to log in
SQL
0 vote311 views1 answer
Sql get guid
SQL