title: How can I cast an int to a bit in MySQL 5.1?
body: <p>I am transitioning from SQL Server to MySQL 5.1 and seem to be tripped up trying to create a table using a select statement so that the column is a bit.</p>
  
  <p>Ideally the following would work:</p>
  
  <pre><code>CREATE TABLE myNewTable AS
  SELECT cast(myIntThatIsZeroOrOne as bit) AS myBit
  FROM myOldtable
  </code></pre>
  
  <p>However sql is very unhappy at casting as a bit.  How can I tell it to select an int column (which I know only has 0s and 1s) as a bit?</p>