MySQL Forums
Forum List  »  Newbie

Re: Cannot create table - cryptic error
Posted by: Peter Brawley
Date: December 04, 2018 10:18PM

Syntax for a virtual column is ...

col_name data_type [GENERATED ALWAYS] AS (expression)
  [VIRTUAL | STORED] [NOT NULL | NULL]
  [UNIQUE [KEY]] [[PRIMARY] KEY]
  [COMMENT 'string']
(https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html)

WB is writing DDL for a uid as a virtual column with no expression (ie "...AS ()..." This thread probably needs to go to the WB forum, but just to confirm that, how did you tell WB to make the uid column virtual?



Edited 1 time(s). Last edit at 12/04/2018 10:24PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Cannot create table - cryptic error
December 04, 2018 10:18PM


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.