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年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ