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.

Thanks

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.