Phpmyadmin Error - error when selecting Auto Increment

Asked

Viewed 326 times

-1

Every time I try to select Auto Increment in a table it happens here -

inserir a descrição da imagem aqui

  • It can only have a single auto increment field, as the error indicates. So you must be trying to modify/add an auto-increment field when you already have one

  • Before clicking on "Guard" click on "Preview SQL" and post the sql expression in your question.

1 answer

0

As stated in the Isac error and comment, can only have one field auto-increment.

You may have other primary and/or foreign keys, depending on your need.


From the print, probably the field id of this table usuarios be it auto-increment.

To confirm, click above and you will have the flag of auto-increment:

flag


If you want to switch to the new column you are creating, uncheck it, and create another field with the flag marked.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.