I have a Price column (DECIMAL 6,2) in my MySQL Products MyISAM table and I'm trying to add a Generated Column to multiply it per 2. I'm trying to use this:
ALTER TABLE Produtos ADD COLUMN Price_double DECIMAL(6,2) AS (Price*2);
Error SQL (1064): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'AS (Preco*2)' at line 1
MySQL only supports generated columns in version 5.7 or later, q.v. the documentation:
As of MySQL 5.7.6, CREATE TABLE supports the specification of generated columns. Values of a generated column are computed from an expression included in the column definition.
However, you syntax appears to be correct, and if you were running 5.7 or later you should not see any error.