Apache Derby DB Error Code 42Y85 – The DEFAULT keyword is only allowed in a VALUES clause when

Posted by AbundantCode

In this blog post, let’s learn about the error message “42Y85- The DEFAULT keyword is only allowed in a VALUES clause when “ in Apache Derby Database and the description of the error.

Error Message

42Y85- The DEFAULT keyword is only allowed in a VALUES clause when

Error Details

The DEFAULT keyword is only allowed in a VALUES clause when the VALUES clause appears within an INSERT statement.