title: MySQL Error 1136:Column count does not match value count at row 1
body: <pre><code>DROP TABLE IF EXISTS student;
  
  CREATE  TABLE student(
    bannerid VARCHAR(9) PRIMARY KEY NOT NULL ,
    lastname VARCHAR(45) NOT NULL ,
    firstname VARCHAR(45) NOT NULL ,
    major VARCHAR(45) NOT NULL DEFAULT 'undeclared' ,
    gpa DECIMAL(2) NOT NULL DEFAULT 0.00 ,
    age INT NOT NULL DEFAULT 18 );
  
    INSERT INTO student VALUES ('b00001111', 'smith', 'fred', 'computer science', 3.12, 20);
    INSERT INTO student VALUES ('b00002222', 'jones', 'herb', 'computer science', 2.00, 19);
    INSERT INTO student VALUES ('b00003333', 'chan', 'jackie', 'computer information systems', 3.50, 50);
    INSERT INTO student VALUES ('b00004444', 'baker', 'al');
    INSERT INTO student VALUES ('b00005555', 'booker', 'sue');
  </code></pre>
  
  <p>This results in the following error and I do not understand why. I want the last two INSERTs to use the default values.</p>
  
  <p>MySQL Error 1136:Column count does not match value count at row 1</p>