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 vote232 views1 answer
Oracle columns table
SQL
0 vote200 views1 answer
Sql check if column exists
SQL
6 votes208 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote192 views1 answer
Sql auto_increment syntax
SQL
7 votes184 views3 answers
Postgresql dump and restore db
SQL
0 vote218 views1 answer
Hashpass
SQL
0 vote219 views1 answer
Query for backup a database at another location in file system
SQL
12 votes181 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote203 views2 answers
Which MySQL statement is used to delete data from a database
SQL
2 votes226 views1 answer
Mariadb select multiple rows into one column
SQL