title: mysql ERROR 1426 (42000): Too big precision 14 specified for column 'time'. Maxi mum is 6
body: <p>guy. I have a strange trouble When I try create a table with timestamp type.</p>
  
  <pre><code>create table `test`
   ( `time` timestamp(14) );
  </code></pre>
  
  <p><em>ERROR 1426 (42000): Too big precision 14 specified for column 'time'. Maximum is 6.</em></p>
  
  <p>I thought the <code>14</code> is a bytes lengths for storage. But it seems like the time precision, because 6 = microsecond(1/1000000), 2012-07-29 00:37:46.<strong><em>000000</em></strong></p>
  
  <p>Anybody can explain it ? I didn't find it in online documentation!
  thanks</p>