JSP Practical Tutorial (the third edition of Tsinghua University Press) problems encountered and explained

Q: I found that when I insert multiple records consecutively in a JSP page, another JSP display page is not displayed in the order in which I inserted them, but instead outputs the table in 26 alphabetical order

A: When using the storage Engine (MyISAM) for full table queries, a table scan is performed, and if the table has not been deleted, replaced, and updated, the query results will be sorted in the order of insertion, if the InnoDB is used as the storage engine When you perform the same operation, the query results are sorted by primary key instead of in the order in which they were inserted. We generally think that the record of select is unordered and requires a certain order, and the plus ORDER BY clause is qualified.

JSP Practical Tutorial (the third edition of Tsinghua University Press) problems encountered and explained