title: Convert BIGINT UNSIGNED to INT
body: <p>I know it is unorthodox and potentially dangerous to want to convert something from a larger to a smaller sized data type. However, in this case, it is extremely unlikely that the value of the <code>BIGINT UNSIGNED</code> column is ever larger than the maximum size of an <code>INT</code> column.</p>
  
  <p>So, using MySQL, I'm reading the table structure. While reading the <code>information_schema.columns.ordinal_position</code> column, I realized that it is of type <code>BIGINT UNSIGNED</code>. Now, I want this as an <code>INT</code> instead for my processing purposes. I want to cast/convert the type in SQL.</p>
  
  <p><code>CAST</code> and <code>CONVERT</code> only allow me to change the sign of the data type, apparently.</p>
  
  <pre><code>SELECT CAST(ordinal_position AS SIGNED)
  FROM information_schema.columns
  </code></pre>
  
  <p>I want the column specifically returned as an <code>INT</code>. E.g. chop the column at the maximum value of an <code>INT</code> and return that value.</p>
  
  <p>For now I will just change the datatype after I pull the value back. But I'd like to know how to do it in SQL.</p>