title: Column cannot be null Mysql
body: <p>Below is my table structure </p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `physicians` (
    `physician_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL,
    `physician_gender` varchar(10) NOT NULL,
    `physician_dob_date` int(11) NOT NULL,
    `physician_dob_month` int(11) NOT NULL,
    `physician_dob_year` year(4) NOT NULL,
    `physician_profession` varchar(50) NOT NULL,
    `medical_specialty` varchar(100) NOT NULL,
    `medical_school` varchar(100) NOT NULL,
    `traning_year` year(4) NOT NULL,
    `physician_minc` varchar(20) NOT NULL,
    `physician_country` varchar(100) NOT NULL,
    `physician_state` varchar(60) NOT NULL,
    `physician_city` varchar(60) NOT NULL,
    `physician_address` varchar(100) NOT NULL,
    `physician_postal_code` varchar(10) NOT NULL,
    `physician_phone_number` varchar(20) NOT NULL,
    `physician_default_msg` longtext NOT NULL,
    PRIMARY KEY (`physician_id`),
    KEY `user_id` (`user_id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
  </code></pre>
  
  <p>I am executing a query and it showing me column can not be null  below is my query</p>
  
  <pre><code>INSERT INTO `physicians` (`user_id`, `physician_gender`, `physician_dob_date`, `physician_dob_month`, `physician_dob_year`, `physician_profession`, `medical_specialty`, `medical_school`, `traning_year`, `physician_minc`, `physician_country`, `physician_state`, `physician_city`, `physician_address`, `physician_postal_code`, `physician_phone_number`, `physician_default_msg`) VALUES (4, 'Female', '5', '7', '1955', '3', '2', '1', '1965', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
  </code></pre>
  
  <p><strong>Error - Column 'physician_minc' cannot be null</strong></p>
  
  <p><code>physician_minc</code> is not mandatory field. How can I fix this problem ?</p>