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 vote399 views1 answer
Oracle show execution plan
SQL
0 vote341 views1 answer
Login phpmyadmin without password
SQL
5 votes344 views3 answers
Select tables from mysql database
SQL
0 vote340 views1 answer
Grepper sql workbench download
SQL
0 vote334 views1 answer
Low level operator in dbms
SQL
1 vote341 views1 answer
Sql Split string function
SQL
5 votes357 views1 answer
Mysql count newlines in field
SQL
3 votes358 views1 answer
Oracle drop user
SQL
0 vote352 views1 answer
Mysql_union
SQL
1 vote338 views1 answer
Sql server update column based on another table
SQL