title: MySQL UUID_SHORT data type
body: <p>I have user table. The primary key is <code>user_id</code> which has a datatype <code>bigint(20)</code>. </p>
  
  <p>I generate a <code>user_id</code> using <code>UUID_SHORT()</code> via trigger below. The issue is I get a warning when I try to insert a record as follows:</p>
  
  <pre><code>Warning: #1366 Incorrect integer value: '' for column 'user_id' at row 1
  </code></pre>
  
  <p>My phpMyAdmin trigger is as follows:</p>
  
  <pre><code>BEGIN
  SET NEW.user_id=UUID_SHORT();
  END
  </code></pre>
  
  <p>Any reason why I am getting this warning? Have I set the datatype correctly? </p>