SQL插入到多列不起作用?

yesterday I had the problem that I couldn't insert multiple values into my columns. It turned out that the problem was that my key was missing an auto_increment. I've been trying to to the same thing(inserting multiple values into columns) now on another table but for some reason it doesn't work for me. I made the same changes as I did to the other table which works now. I can't imagine what I could've missed, can anyone help me with this? Here the table specification and error: error

评论
  • Rose
    Rose 回复

    当您将PK标记为自动递增时,您不必再为该条目插入值,因为它将自动递增,因此不会因为与以前的PK条目不同而触发任何重复的问题。我建议您仅添加非PK列的值。