Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
โ11-16-2019 06:19 AM
0 REPLIES 0