title: How do I stop a MySQL decimal field from being rounded?
body: <p>I have a table in MySQL with a field that is decimal, length 9, unsigned. I'm using it for prices.</p>
  
  <p>After I insert the data, and query for it, it has all been rounded and the decimal has been removed.</p>
  
  <p>I'm confused as to why.</p>
  
  <p>Troubleshooting tips?</p>
  
  <hr>
  
  <p><strong>Host</strong>: web.com</p>
  
  <p><strong>phpMyAdmin version</strong>: 2.11.10.1</p>
  
  <p><strong>MySQL client version</strong>: 5.0.95</p>