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
posta 3 anni fa585 visualizzazioni
1 Risposta
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
con risposta 3 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande