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);
Are there any code examples left?
New code examples in category SQL