Mysql calculated column

-- MySQL / Oracle:
ALTER TABLE table_name ADD double_count NUMBER(10, 2)
    GENERATED ALWAYS AS (account * 2) VIRTUAL;
-- SQL Server
ALTER TABLE table_name ADD [double_count] AS (acccount * 2);

Source: mysqltutorial.org

Similar codes

5 votes326 views4 answers
Mysql on duplicate key update
SQL
0 vote357 views1 answer
Move table to a different schema
SQL
0 vote364 views2 answers
How to drop mili second in sql
SQL
23 votes320 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote333 views1 answer
Mysql check if lowercase
SQL
0 vote364 views2 answers
Impala rename column name
SQL
0 vote334 views1 answer
Not equal to blank in mysql
SQL
0 vote367 views1 answer
Stored procedure function relation
SQL
1 vote328 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
1 vote327 views1 answer
Join to find results not in another table
SQL