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

4 votes154 views2 answers
Tables in sql
SQL
4 votes141 views2 answers
Postgre sql create table
SQL
0 vote95 views1 answer
Print sum of values sql
SQL
1 vote151 views1 answer
Drop primary key oracle
SQL
51 votes368 views6 answers
Installing mysql on ubuntu
SQL
4 votes134 views1 answer
Sql delete where in select
SQL
0 vote138 views1 answer
Get clob size oracle
SQL
8 votes140 views1 answer
Sql remove leading spaces
SQL
0 vote142 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote141 views1 answer
Populate db from command line postgres
SQL