title: Can some SQL queries be executed while the others fail?
body: <p>I have read from some posts that it is a better practice to execute queries one by one instead of doing the multi-query function in PHP files. I wonder say I have two <code>mysqli_query</code> functions, is it possible that the first query succeeds and MySQL Database has been changed accordingly when the next query fails?</p>
  <p>If this is the case, I need to execute the second query only if the first succeeded, for example ( create table, then insert data to that table). Is putting an if statement for the condition that the first query is successful the best way of ensuring this?</p>