mysql – “SELECT * FROM view_table WHERE cause”=>但结果总是重新排序

[weixin_38067871]

在SELECT * FROM view_table中结果始终为 ----------------------- || id || author || ----------------------- || 1 || a || <-- || 1 || c || <-- || 1 || b || <-- || 2 || d || || 3 || e || 但是当SELECT * FROM view_table WHERE id = 1时,结果是 ----------------------- || id || author || ----------------------- || 1 || a || || 1 || b || || 1 || c || 要么 ----------------------- || id || author || ----------------------- || 1 || b || || 1 || c || || 1 || a || 要么 ----------------------- || id || author || ----------------------- || 1 || a || || 1 || c || || 1 || b || 要么 .. 我想SELECT * FROM view_table WHERE id = 1并以与SELECT * FROM view_table相同的顺序获取结果.如何解决它 谢谢.

[weixin_38088445]

除非使用ORDER BY子句,否则永远不会保证结果的顺序.您想如何订购,取决于您. 例如, SELECT * FROM view_table WHERE id = 1 ORDER BY author 这将根据作者的名称(从A到Z,或Z,如果您使用ORDER BY作者DESC)对其进行排序. 或者,您可以添加一个Created列,然后按该列排序,该列保存创建时的时间戳.这可能会模仿您想要保留的订单.