title: Incorrect DECIMAL value when inserting MySQL 1
body: <p>Name  Type</p>
  
  <p>price decimal(7,0)</p>
  
  <pre><code>INSERT INTO products (uid, item_code,item_name, brand_name,model_number,weight,dimension,description,category,quantity,price,imagename) 
  VALUES (1, '01','Lenovo','Lenovo laptop','qwqeiu145','50kg','5x9','Lenovo is the best','Computers &amp; Accessories','2','$250.0000','lenovo');
  </code></pre>
  
  <p>THIS IS THE ERROR</p>
  
  <blockquote>
    <p>1366 - Incorrect decimal value: '$250.0000' for column 'price' at row
    1</p>
  </blockquote>