Generated Columns
I am trying to create a generated column, but I keep getting the error message, e.g.
"Error 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 'GENERATED ALWAYS AS ('test1') VIRTUAL AFTER `test1`' at line 2
SQL Statement:
ALTER TABLE `test`.`contacts`
ADD COLUMN `test2` VARCHAR(45) GENERATED ALWAYS AS ('test1') VIRTUAL AFTER `test1`"
I have checked my syntax carefully against published examples, and have tried different variations. MySQL Workbench 6.3 Community
P.S. The first few times I tried to post, I received this message, "Sorry, you do not have permission to post/reply in this forum." without any indication of what was wrong. I then approached the forum from a different route, and was allowed to post.
Subject
Views
Written By
Posted
Generated Columns
1223
April 27, 2017 01:29PM
475
April 28, 2017 01:29AM
375
April 28, 2017 06:48AM
393
April 28, 2017 09:47AM
449
April 28, 2017 09:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.