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 vote308 views1 answer
Sql select most frequent value in column
SQL
2 votes325 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote608 views1 answer
Power bi connect to postgresql
SQL
2 votes290 views1 answer
Sqlite show table indexes
SQL
0 vote297 views1 answer
Sql select with apostrohpe
SQL
5 votes290 views2 answers
Oracle tables with column name
SQL
0 vote355 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote306 views1 answer
Android sqlite add column if not exists
SQL
0 vote326 views1 answer
Sql change primary key to composite key
SQL
0 vote316 views1 answer
Kill mysqld_safe process mariadb
SQL