title: "Error Code: 1109. Unknown table 'LeaderBoard' in field list" in MYSQL
body: <p>I began getting the error:</p>
  
  <p>Error Code: 1109. Unknown table 'LeaderBoard' in field list</p>
  
  <p>after I implemented the following trigger:</p>
  
  <pre><code>USE `broadside`;
  DELIMITER $$
  CREATE DEFINER=`root`@`localhost` TRIGGER `LeaderBoard_AINS` 
  AFTER INSERT ON `LeaderBoard` 
  FOR EACH ROW
  BEGIN
      if ((broadside.LeaderBoard.username= NEW.username) AND (broadside.LeaderBoard.userscore&lt; NEW.userscore))
      then
          DELETE FROM `broadside`.`LeaderBoard`
          WHERE (username = NEW.username AND userscore != NEW.userscore);
      end if;
      if (broadside.LeaderBoard.username= NEW.username AND broadside.LeaderBoard.userscore&lt; NEW.userscore)
      then
          DELETE FROM `broadside`.`LeaderBoard`
          WHERE (username = NEW.username AND userscore != NEW.userscore);
      end if;
  end
  </code></pre>
  
  <p>The table name is LeaderBoard and the database name is broadside. It compiled fine, but when i try inserting an element and the trigger actually gets triggered I get the 1109 error shown above. Can someone please help?</p>