Can Create Index create the primary key Primary Key in MySQL

2020-05-09 19:24:42
OfStack

                    Can Create Index create the primary key Primary Key in MySQL?

The answer:

No, it must be created with Alter table.

MySQL1 the maximum allowed effective length of an indexed column. Not all data in the column is indexed

MyISAM is 1000 bytes

InnoDB is 767 bytes

Notice this is a byte.

MySQL Create Data Table and Establish Primary Foreign Key Relationship Detailed Explanation
MySQL creates primary key foreign key and composite primary key statements
Differences between KEY PRIMARY KEY UNIQUE KEY and INDEX in MySQL
Analysis of the relationship and difference between MySQL primary key and index
MySQL creates index of Create Index methods and syntax structures and examples