How to make the column unique after the table is created the database?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
14 views
I created a table in the database and realized that I forgot to make a column unique. Navigate to the composition tab, put a tick in the column A_I, save — gets error:
5aead9d2897c7153279085.png
by | 14 views

4 Answers

0 like 0 dislike
Tab "Structure" → click the right column "Primary" → "Edit" → tick A_I
by
0 like 0 dislike
mysql alter table
ps I looked at the screenshot and there kod_roditel. I don't know how to help here.
by
0 like 0 dislike
A_I is not a unique column, and autoincrementing column.

Read about the indexes, but rather unique indexes.
by
0 like 0 dislike
press structure looking for the line where the bold is written kod_roditel and on the right of this row of squares is different, when hovering one can find the box unique.
by

Related questions

0 like 0 dislike
1 answer
asked Apr 20, 2019 by malishkina2502
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
110,608 questions
257,186 answers
0 comments
35,458 users