Multiple Insert - Column count doesn't match value count at row 1

[boo_lolly]

I cannot for the life of me figure this out. PhpMyAdmin puts there error somewhere around the word VALUES.

      INSERT INTO
        `tasks` (
          `id`,
          `challenge_id`,
          `title`,
          `frequency`,
          `category`,
          `description` 
      )
      VALUES (
        (
          "",
          12,
          "title1",
          "frequency1",
          "category1",
          "somedesc1"
        ),
        (
          "",
          12,
          "title2",
          "frequency2",
          "category2",
          "somedesc2"
        ),
        (
          "",
          12,
          "title3",
          "frequency3",
          "category3",
          "somedesc3"
        )
      ); 

 

I have not left out any columns in the query on the table `tasks`. Can anyone else see what i'm doing wrong? I've been banging my head over this for like an hour...

[PravinS]

Try this

 

 

      INSERT INTO
        `tasks` (
          `id`,
          `challenge_id`,
          `title`,
          `frequency`,
          `category`,
          `description` 
      )
      VALUES 
        (
          "",
          12,
          "title1",
          "frequency1",
          "category1",
          "somedesc1"
        ),
        (
          "",
          12,
          "title2",
          "frequency2",
          "category2",
          "somedesc2"
        ),
        (
          "",
          12,
          "title3",
          "frequency3",
          "category3",
          "somedesc3"
        ); 

 

 

 

[boo_lolly]

pbs,

 

THAT TOTALLY WORKED!

 

I can see that I had an extra closing parenthesis at the end that was not necessary and the opening parenthesis right after VALUES was also not necessary