Error 1054 Unknown Column while Inserting into Table in Aurora MySQL

0

I'm getting a very frustrating error while attempting to insert a simple record into a table in AWS Aurora MySQL, using Workbench to connect. Even when using the scripting tool by right-clicking the table name and selecting "Send to SQL Editor-->Insert Statement" or by doing a select top 1000 rows and utilizing the grid function to enter, then "Apply" the new row, it does not work.

The error I continue to get is Error Code: 1054. Unknown column 'NEW.USER_ID' in 'field list'

There is very clearly a column called USER_ID on my table. Any ideas? I'm connected as the admin user. I've been able to execute create trigger and create view scripts on this database, but just not insert a row into this table.

ssktx
已提问 3 年前585 查看次数
1 回答
0

Turns out I had a trigger on the table that had some bad syntax in it, fixed that and it all worked fine

ssktx
已回答 3 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则