I created a new table and forgot to set the primary key with an auto_increment.
I went back and use:
ALTER TABLE table ADD PRIMARY KEY AUTO_INCREMENT (column);
However, now whenever I try to insert a new row of data, I get the error message "Duplicate entry '0' for primary key'.
It's obviously still not using the auto increment! I've checked that
describe table; shows it with the auto_incremement, and I've also tried re-setting the value of auto_increment, but no luck.
Can anyone help?