when i make table structure export, the result is not efficent
for ex
it makes alter table statement and after it makes another alter just to set auto increment
there should be single alter table where possible
thanks
An export of table(s) from phpMyAdmin has the following order.
Create table statement without auto increment, indexes and foreign keys
Insert statement for data
Alter table statement to create indexes
Alter table statement to add auto increment
Alter table statement to add foreign key constraints
AFAIK, creating index and foreign keys only after inserting data makes inserting much efficient.
Indexes of the foreign table needs to be in place to add foreign key constraints. So we have to separate index creation and foreign key constraint adding with indexes being added first.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is more of a feature request IMO
An export of table(s) from phpMyAdmin has the following order.
AFAIK, creating index and foreign keys only after inserting data makes inserting much efficient.
Indexes of the foreign table needs to be in place to add foreign key constraints. So we have to separate index creation and foreign key constraint adding with indexes being added first.
See https://sourceforge.net/p/phpmyadmin/feature-requests/1004/
Ticket moved from /p/phpmyadmin/bugs/4968/