MySQL Forums
Forum List  »  MySQL Workbench

Forward engineered generated column inserts error 3105
Posted by: James Strong
Date: March 25, 2021 12:35PM

Hi I'm trying to use MySQL Workbench .23 to insert a row into a table that has a generated column but keep getting an error about the value entered is not allowed.

I've tried null, \func, DEFAULT and even empty string and the SQL script instead of leaving that field out puts a value in the field.

How do I get Workbench to stop generating a value for that virtual field and or what value should I put since null doesn't work.

It is a virtual column and not a stored one.


Options: ReplyQuote

Written By
Forward engineered generated column inserts error 3105
March 25, 2021 12:35PM

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.