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

1 vote264 views1 answer
Oracle split string
SQL
0 vote251 views1 answer
Ffeathers express mysql application users login
SQL
2 votes267 views4 answers
Sql query interview questions
SQL
0 vote262 views1 answer
Postgresql heritage
SQL
0 vote315 views1 answer
Mssql last day of month
SQL
0 vote262 views1 answer
Oracle service name view
SQL
1 vote259 views1 answer
Show table status command in mysql
SQL
0 vote282 views2 answers
Connect to mysql server mac terminal
SQL
0 vote270 views1 answer
Sql declare variable single line
SQL
10 votes281 views2 answers
Select nextval from sequence oracle
SQL