INSERT INTO design_materials(`id`,`design_id`,`material`,`quantity`)
    VALUES(NULL, 11, '1', 3)
    ON DUPLICATE KEY UPDATE `design_id` = VALUES(`design_id`), 
                            `material` = VALUES(`material`), 
                            `quantity` = VALUES(`quantity`)

这是“where子句”中未知列“design\u materials.material”的错误。如下图所示，所有表列都是正确的
https://i.stack.imgur.com/igr8e.jpg