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 vote121 views1 answer
Sql dmv to capture updates
SQL
5 votes128 views1 answer
Oracle sysdate - 1 month
SQL
12 votes114 views4 answers
How to take database dump in postgresql
SQL
1 vote117 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote126 views2 answers
How to add CHECK constraint to a column in postgres
SQL
3 votes134 views3 answers
Restart mysql mac
SQL
0 vote120 views1 answer
How to check the port of mysql installation in mac
SQL
6 votes125 views4 answers
Remove spaces sql server
SQL
0 vote111 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote116 views1 answer
Select multiple row from primary key sql
SQL