title: What is the correct default value for a MySQL decimal field?
body: <p>I have a <code>decimal</code> field in my MySQL database. I have defined it as this:
  <code>decimal(1,1) UNSIGNED NULL</code>. But I would like to set a default value for it like <code>7.0</code>, and this is the problem I have. Whenever I want to set this value, I get this error:  </p>
  
  <pre><code>Invalid default value ...
  </code></pre>
  
  <p>I also tried to set it as <code>7,0</code> and <code>7</code> but it resulted the same error. What is the correct default value for a MySQL decimal field?  </p>
  
  <p><em>Note: I am using Navicat for MySQL</em></p>