Code Inspection: Auto-increment duplicate
Reports tables that contain two columns with an automatic increment. In MySQL, Microsoft SQL Server, and Db2 dialects, a table can have only one field with a auto-increment option, and this field must be a key.
The AUTO_INCREMENT constraint for
c2 will be highlighted as
c1 already has this constraint. To fix the warning, you can make
id a primary key and delete AUTO_INCREMENT for
Suppress an inspection in the editor
Place the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.