Records in database tables are stored in sets. The database cannot guarantee that the order in which records are stored is the order in which you insert records.
So according to what you said, if you want to get the previous or next record of a record, you must use the order clause to sort the retrieved results, and then use the limit clause to get the record at the corresponding position.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Records in database tables are stored in sets. The database cannot guarantee that the order in which records are stored is the order in which you insert records.
So according to what you said, if you want to get the previous or next record of a record, you must use the order clause to sort the retrieved results, and then use the limit clause to get the record at the corresponding position.