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
feita há 3 anos585 visualizações
1 Resposta
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
respondido há 3 anos

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas