title: MYSQL trigger giving errors
body: <p>Accounts table: <a href="https://i.stack.imgur.com/sqL1E.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>MYSQL terminal: <a href="https://i.stack.imgur.com/dgF7k.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>I'm making a trigger to the Accounts table that will respond to any update or insertion into the database that would give an account type any value other than credit, checking, or cash the value cash.</p>
  
  <p>I tried implementing the trigger (it compiled) but it's giving me an error whenever I try to add something that's not cash, credit, and checking. What could cause/fix this error?</p>