MySQL Forums
Forum List  »  MySQL Workbench

Generated Columns
Posted by: Tharpa roberts
Date: April 27, 2017 01:29PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Generated Columns
211
April 27, 2017 01:29PM
99
April 28, 2017 01:29AM
90
April 28, 2017 06:48AM
86
April 28, 2017 09:47AM
110
April 28, 2017 09:54AM
76
May 02, 2017 12:42AM


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.