php - mysql alter table order by not working -


i have searched on net lot. understand thing has been faced many people before me , has been filed mysql bugs. couldn't find solution this. problem can't command working-

alter table areas order area_name; 

i warning-

order ignored there user-defined clustered index in table 'areas' 

i want sort table on basis of 'area_name', is, names of areas. add, trying in database of laravel app.

if db engine innodb, can't this.

from doc:

order not make sense innodb tables because innodb orders table rows according clustered index.


Comments

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

php - Magento - Deleted Base url key -

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -