title: MySQL Decimal Type Out Of Range Error
body: <p>This code: </p>
  
  <pre><code>DROP DATABASE IF EXISTS `my_db`;
  CREATE DATABASE `my_db`; 
  CREATE TABLE `my_db`.`my_table` (
      `id` integer NOT NULL AUTO_INCREMENT, 
      `multiplier` decimal(18, 10) NOT NULL, 
      PRIMARY KEY (`id`)
  ) Engine=InnoDB;
  
  INSERT INTO `my_db`.`my_table` (`multiplier`) VALUES (100000000.0);
  </code></pre>
  
  <p>Returns an error: </p>
  
  <pre><code>Error Code: 1264. Out of range value for column 'multiplier' at row 1
  </code></pre>
  
  <p>Why? There are only 9 digits before comma whereas the column should work until 18 digits - or am I missing something here? Thank you. </p>