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

0 vote245 views1 answer
Savepoint mysql script
SQL
34 votes226 views6 answers
Sql change data type
SQL
0 vote225 views2 answers
Oracle create chain rule
SQL
0 vote222 views1 answer
Sql select rows with different values in one column
SQL
0 vote216 views1 answer
Remove default constraint sql server
SQL
0 vote222 views1 answer
Many rows to 1 string mysql
SQL
1 vote237 views1 answer
Sql restore backup query
SQL
0 vote225 views1 answer
Laravel eloquent get generated sql
SQL
1 vote221 views1 answer
Mariadb alter user host
SQL
0 vote222 views1 answer
Alter table myisam to innodb
SQL