title: Column count doesn't match value count at row 1 in MySQL
body: <p>I have created a table with the following query:</p>
  
  <pre><code>CREATE TABLE `dailydata` (
    `id`         int(9)         NOT NULL,
    `Date`       varchar(100)   NOT NULL,
    `EmpID`      varchar(100)   NOT NULL,
    `name`       varchar(100)   NOT NULL,
    `TeamName`   varchar(100)   NOT NULL,
    `active`     varchar(100)   NOT NULL,
    `idle`       double         NOT NULL,
    `Stime`      double         NOT NULL,
    `Etime`      varchar(100)   NOT NULL,
    `Inofficehr` decimal(20,2)  NOT NULL,
    `activehr`   double(19,2)   NOT NULL,
    `idlehr`     double(19,2)   NOT NULL,
    `Timestamp`  timestamp      NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
     CURRENT_TIMESTAMP) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  </code></pre>
  
  <p>Set Primary key For 'id' column:</p>
  
  <pre><code>ALTER TABLE `dailydata`ADD PRIMARY KEY (`id`);
  </code></pre>
  
  <p>Now I'm trying to insert the data with this code:</p>
  
  <pre><code>INSERT INTO dailydata 
  SELECT A.Date, A.EmpID, B.name, B.TeamName, 
  SUM(CASE WHEN State = 'active' THEN A.MinutesatState ELSE 0 END) AS active,
  SUM(CASE WHEN State = 'idle' THEN A.MinutesatState ELSE 0 END) AS idle,
  Min(A.Statestarttime) AS Stime, MAX(A.StateEndtime) AS Etime,
  ROUND((TIME_TO_SEC(MAX(A.StateEndtime))/60 - 
  TIME_TO_SEC(MIN(A.StateStarttime))/60)/60,2) as Inofficehr, 
  ROUND(SUM(CASE WHEN State = 'active' THEN A.MinutesatState ELSE 0 END)/60,2) 
  AS activehr, 
  ROUND(SUM(CASE WHEN State = 'idle' THEN A.MinutesatState ELSE 0 END)/60,2) 
  AS idlehr 
  FROM time A join ttld.login B on A.EmpID=B.username 
  WHERE A.Date='01-01-2019' AND A.Statestarttime &lt;&gt;'' AND A.StateEndtime &lt;&gt;'' 
  GROUP BY A.EmpID;
  </code></pre>
  
  <p>But I'm getting this error:</p>
  
  <blockquote>
    <p>#1136 - Column count doesn't match value count at row 1</p>
  </blockquote>
  
  <p>I understand I have not define the ID in my insert code and the reason for it is I want it to auto populate. </p>
  
  <p>How can I modify my <code>INSERT</code> query code to do so... </p>