title: inserting into new added columns in an existing table
body: <p>I have a table 'user' already in db with fields </p>
  
  <pre><code>create Table user (
  id INT(6) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  username varchar(20) NOT NULL,
  password varchar(20) NOT NULL,
  profilename varchar(20) NOT NULL,
  email varchar(40) NOT NULL,
  socialemail varchar(40) NOT NULL)engine=InnoDB;
  </code></pre>
  
  <p>The stated columns also contain values</p>
  
  <p>I altered the table and added some more columns</p>
  
  <pre><code>ALTER TABLE user
  ADD COLUMN enabled varchar(1),
  ADD COLUMN accountnonexpired varchar(1),
  ADD COLUMN credentialsnonexpired varchar(1),
  ADD COLUMN accountnonlocked varchar(1);
  </code></pre>
  
  <p>Now when I am inserting values into new columns with the below command in MYSQL.</p>
  
  <pre><code>insert into user
  (id,enabled,accountnonexpired,credentialsnonexpired,accountnonlocked) values ('1','Y','Y','Y','Y'),('2','Y','Y','Y','Y');
  </code></pre>
  
  <p>I am getting an error </p>
  
  <pre><code>Error Code: 1364. Field 'username' doesn't have a default value
  </code></pre>
  
  <p>Can anyone tell me why?
  What should be the correct way to insert values in new columns?</p>
  
  <p><img src="https://i.stack.imgur.com/AUsY5.jpg" alt="enter image description here"></p>