ref:https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
if InnoDB table, the table primary key is implicitly part of the index. Dose it order by primary key when value of secondary index is identical?
could you help me answer this question
some references would be better, thanks.
New contributor
chi tian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.