Auto increment doesn't increment when using DEFAULT, but rather gives 0; Insert statement gives erro

RabinGomes — Sat, 16 Nov 2019 14:19:03 GMT

According to a textbook and the Internet, using DEFAULT in a column that's defined as auto increment will use some generated value.

For the second issue, the solution is to disable the safety update option or something similar. I am using a primary key in the WHERE clause and MySQL Workbench still complains about not using a primary key.

What to do?

topic Auto increment doesn't increment when using DEFAULT, but rather gives 0; Insert statement gives erro in Integration and Testing

Auto increment doesn't increment when using DEFAULT, but rather gives 0; Insert statement gives erro