MySQL Workbench auto increment with Examples

What is auto increment?

Auto Increment is a function that operates on numeric data types. It automatically generates sequential numeric values every time that a record is inserted into a table for a field defined as auto increment.

When use auto increment?

In the lesson on database normalization, we looked at how data can be stored with minimal redundancy, by storing data into many small tables ,related to each other using primary and foreign keys.

Symptoms

The auto-increment checkbox is disabled in designer and I can't turn it on.

Solution

Solution is pretty simple. Just use another button. Let's look at the image. Number 1 shows, that auto-increment button is disabled. But near the number 2, there is another checkbox, where you can set the auto-increment.

Post a Comment

0 Comments