title: How to force view creation with MySQL?
body: <p>I have a view that MySQL refuses to create, because it references a column that doesn't exist:</p>
  
  <pre><code>ERROR 1054 (42S22): Unknown column 'd.completed' in 'where clause'
  </code></pre>
  
  <p>Is there any way to force MySQL to create this view?  (Even though it will not be possible to use it until the column is created.)</p>
  
  <p>(The reason I want to do this is I had a working view, which subsequently broken after a column was deleted.  I'm creating a schema migration to fix the view, but, as with all my other migrations, I would also like to be able to revert to the current situation.)</p>