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
gefragt vor 3 Jahren585 Aufrufe
1 Antwort
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
beantwortet vor 3 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen