How to fix database error (MODIFY `ID` int(11) NOT NULL)?

Question

MySQL

Help kind people) to understand the essence of how to solve such a problem in the Bitrix database!

Mistake! Mysql Query Error: ALTER TABLE `b_socialservices_user` MODIFY `ID` int(11) NOT NULL auto_increment [Incorrect table definition; there can be only one auto column and it must be defined as a key]

Answer 1

there can be only one auto column and it must be defined as a key - what exactly is not clear in this phrase?

Answer 2

Only one column can be auto_increment and must be declared as a key (index or primary key)