cancel
Showing results for 
Search instead for 
Did you mean: 

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

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?

RabinGomes
Member
0 REPLIES 0