title: MySQL error 1443 workaround
body: <p>I believe my question can be referred to <a href="https://stackoverflow.com/questions/1225496/mysql-1443-what-does-it-mean">another question</a> with almost the same title, but the answer was unfortunately not clear enough for me and that question is 6 years old too, maybe there are already some changes made to MySQL. </p>
  
  <p>I wanted to delete a row(s) from a table without even updating/inserting/deleting rows from the view tables, from what I know, mysql unfortunately prevents us from making changes to a table that is referencing to a view table. 
  I <strong>need</strong> to reference to the table which brings me to option 2 and my  question: </p>
  
  <p>How can I "<strong>dump the list to a temporary table and use that for your subquery</strong>." or <strong>is there a workaround to make this code work</strong>?</p>
  
  <p>I am using MySQL version 5.6.12 and
  the code I'm working on: </p>
  
  <pre><code>DELETE FROM student
     WHERE (SUBSTR(student.stud_no,1,4) = 1234)
         AND NOT EXISTS
            (SELECT vr.stud_no FROM viewroom vr WHERE
             vr.stud_no = student.stud_no)
         AND NOT EXISTS
            (SELECT vlnr.stud_no,vlnr.status FROM viewlateststudentnr 
             vlnr WHERE (student.stud_no = vlnr.stud_no) AND (vlnr.status = 'confirmed') )
  </code></pre>
  
  <p>And the error :  </p>
  
  <blockquote>
    <p>1443 - The definition of table 'vr' prevents operation DELETE on table 'student'.</p>
  </blockquote>