Ta requête mentionne 3 colonnes et 150 valeurs pour le même enregistrement. Si tu veux insérer plusieurs enregistrements il ne faut pas oublier d'encadrer chacun d'entre eux par des parenthèses.
[code]INSERT PRODUIT_TYPE (IdProduit, IdTheme, DateModification)
VALUES
('7919','1490','2007-01-24'),
('9133','1490','2007-01-24'),
('9625','1490','2007-01-24')[/code]

salut tout le monde,

Quelqu'un pourrait m'expliquer pourquoi cette requête ne fonctionne pas chez moi :roll: ?
[code]

INSERT PRODUIT_TYPE (IdProduit, IdTheme, DateModification)
VALUES (
'7919','1490','2007-01-24',
'9133','1490','2007-01-24',
'9625','1490','2007-01-24',
'11148','1490','2007-01-24',
'13740','1490','2007-01-24',
'14778','1490','2007-01-24',
'15506','1490','2007-01-24',
'15603','1490','2007-01-24',
'17464','1490','2007-01-24',
'19281','1490','2007-01-24',
'19414','1490','2007-01-24',
'20925','1490','2007-01-24',
'25725','1490','2007-01-24',
'25735','1490','2007-01-24',
'25758','1490','2007-01-24',
'25794','1490','2007-01-24',
'25802','1490','2007-01-24',
'25803','1490','2007-01-24',
'25841','1490','2007-01-24',
'25843','1490','2007-01-24',
'26780','1490','2007-01-24',
'30869','1490','2007-01-24',
'30890','1490','2007-01-24',
'30891','1490','2007-01-24',
'31620','1490','2007-01-24',
'31623','1490','2007-01-24',
'34590','1490','2007-01-24',
'34602','1490','2007-01-24',
'33972','1490','2007-01-24',
'34599','1490','2007-01-24',
'34700','1490','2007-01-24',
'34729','1490','2007-01-24',
'34603','1490','2007-01-24',
'34628','1490','2007-01-24',
'34639','1490','2007-01-24',
'34640','1490','2007-01-24',
'34647','1490','2007-01-24',
'34656','1490','2007-01-24',
'34658','1490','2007-01-24',
'34664','1490','2007-01-24',
'34669','1490','2007-01-24',
'34670','1490','2007-01-24',
'34673','1490','2007-01-24',
'34679','1490','2007-01-24',
'34680','1490','2007-01-24',
'34681','1490','2007-01-24',
'34687','1490','2007-01-24',
'34699','1490','2007-01-24',
'34712','1490','2007-01-24',
'34720','1490','2007-01-24',
'34726','1490','2007-01-24',
'34736','1490','2007-01-24',
'34739','1490','2007-01-24'
)
[/code]

j'ai l'erreur suivante : 1136 - Column count doesn't match value count at row 1


merci