MySQL Unknown column 'columname' in 'field list'
I have a row in MySQL (MariaDB) as follows:
Code:
select orgId, personId, MemberId from orgMember where personId = 252 Code:
update orgMember set memberId = 255 where personId = 252 and orgId = 1 Code:
Field Type Null Key Default Extra |
Found the problem! I had a trigger on this table that had an invalid syntax with reference to the orgId column. Fixed the trigger and the update worked. Not real obvious from the error that the problem was in the trigger.
|
All times are GMT -5. The time now is 09:36 AM. |