MySQL How to set the Primary Key on phpMyAdmin

Question

Help  First time using phpMyAdmin  The column that I intend to set as a primary key is of TEXT in phpMyAdmin  it gave me an error message  the primary key can t be set  And I don t want to change it to INT  How can I solve this  Million thanks   PS  I haven t input any values or relate any other tables on this table yet

User · Answer

MySQL can index the first x characters of a column but a TEXT type is of variable length so mysql cant assure the uniqueness of the column If you still want text column use VARCHAR

User · Answer

You can view the INDEXES column below where you find a default PRIMARY KEY is set  If it is not set or you want to set any other variable as a PRIMARY KEY then   there is a dialog box below to create an index which asks for a column number  either way you can create a new one or edit an existing one The existing one shows up a edit button whee you can go and edit it and you re done save it and you are ready to go

User · Answer

You can t set the field having data-type  text   Only because of that thing you are getting this error  Try to change the data-type with int

User · Answer

You can set a primary key on a text column  In phpMyAdmin  display the Structure of your table  click on Indexes  then ask to create the index on one column  Then choose PRIMARY  pick your TEXT column  but you have to put a length big enough so that its unique

[mysql] MySQL: How to set the Primary Key on phpMyAdmin?

Examples related to mysql

Examples related to phpmyadmin