INSERT INTO `products` (`products_id`,`products_quantity`,`products_on_order`,`products_model`,`products_image`,`products_subimage1`,`products_subimage2`,`products_subimage3`,`products_subimage4`,`products_subimage5`,`products_subimage6`,`products_price`,`products_cost`,`products_date_added`,`products_last_modified`,`products_date_available`,`products_weight`,`products_status`,`products_invisible`,`products_tax_class_id`,`manufacturers_id`,`products_ordered`,`products_compare_status`,`products_compare_expedition`,`products_price1`,`products_price2`,`products_price3`,`products_price4`,`products_price5`,`products_price6`,`products_price7`,`products_price8`,`products_price1_qty`,`products_price2_qty`,`products_price3_qty`,`products_price4_qty`,`products_price5_qty`,`products_price6_qty`,`products_price7_qty`,`products_price8_qty`,`products_qty_blocks`,`subscription_periodicity`) VALUES ('6192','-8','0','B3500','Image/access/scandinave/3500.jpg','','','','','','','3.3445','0.0000','0000-00-00 00:00:00','2007-10-29 08:18:00','','0.000','1','0','2','','9','1','','2.5084','2.5084','0.0000','0.0000','0.0000','0.0000','0.0000','0.0000','5','10','0','0','0','0','0','0','1','');
J'ai essayer de remplacer INSERT INTO par REPLACE INTO et je me retrouve avec des champs null pour les champs qui ne sont pas concerné par la requete
Partager