MySQL ã® order by 㨠index - ã¾ã‚‹ã¾ã‚‹ã“ãµã“ãµMySQLã® order by 㨠index ã®ä»•çµ„ã¿ãŒã‚ã‹ã‚‰ãªããªã£ãŸã®ã§èª¿æŸ»ã€‚ å‰æã®è‡ªåˆ†ã®ä»®å®š MySQLã¯é™é †ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’サãƒãƒ¼ãƒˆã—ãªã„ã®ã§ order by desc ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’使用ã§ããªã„ (user_id, point)ã¨ã„ã†è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Œã°ã€where user_id = ? order by point ascã¨ã„ã†ã‚¯ã‚¨ãƒªã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’最大é™ã«ä½¿ç”¨ã§ãã‚‹ 準備 MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ 5.1.61 CREATE TABLE `sample` ( `id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL, `point` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `i1` (`user_id`,`point`) )
Index Hintã®ä½¿ã„ã©ã - Qiita
[MySQL]WHEREå¥ã¨ORDER BYå¥ã®ä¸¡æ–¹ãŒä½¿ã‚ã‚Œã¦ã„ã‚‹å ´åˆã®INDEX![[MySQL]WHEREå¥ã¨ORDER BYå¥ã®ä¸¡æ–¹ãŒä½¿ã‚ã‚Œã¦ã„ã‚‹å ´åˆã®INDEX](https://cdn-ak-scissors.b.st-hatena.com/image/square/2f5ca69a1238ee65350cee5bf801c4b58342fe81/height=288;version=1;width=512/https%3A%2F%2Fdaybydaypg.com%2Fwp-content%2Fuploads%2F2017%2F08%2Fmysql.png)
MySQL with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - クックパッド開発者ブãƒã‚°
{{#tags}}- {{label}}
{{/tags}}