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

3 votes298 views1 answer
Créer une table sql
SQL
1 vote287 views1 answer
Oracle activate job
SQL
2 votes297 views1 answer
Guid to string sql
SQL
0 vote280 views1 answer
Mysql local password denied
SQL
3 votes271 views4 answers
Show sql server database
SQL
10 votes303 views3 answers
Join multiple tables sql
SQL
7 votes286 views1 answer
Sql management studio display line numbers
SQL
0 vote283 views2 answers
How to save result of sqlite query in a table
SQL
4 votes302 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote289 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL