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

0 vote283 views1 answer
Recover deleted data from mysql database
SQL
0 vote277 views1 answer
Drop all tables in azure sql database
SQL
0 vote327 views1 answer
Oracle chain step succeeded
SQL
0 vote270 views1 answer
How to connect to mysql in ef 6
SQL
0 vote291 views3 answers
Query string not ending with with vowels
SQL
0 vote287 views1 answer
Sql server union if table exist
SQL
4 votes287 views1 answer
Oracle session date format
SQL
0 vote283 views1 answer
Nth max in my sql
SQL
0 vote329 views1 answer
Sql int vs integer
SQL
6 votes285 views2 answers
Where clause in sql
SQL