mysql中如何选出id较大的前10条记录，现在的表中数据id是乱序的 在MYSQL中怎么写SQL语句，能取到表中按ID降序排列的前...
mysql\u5982\u4f55\u53d6\u5f97\u7b5b\u9009\u51fa\u768410\u6761\u6570\u636e\u7684\u6700\u5927id-CSDN\u8bba\u575bselect max(id) from tablename limit 10;
\u6211\u4eec\u77e5\u9053\u4ece MySQL \u8868\u4e2d\u4f7f\u7528 SQL SELECT \u8bed\u53e5\u6765\u8bfb\u53d6\u6570\u636e\u3002
\u5982\u679c\u6211\u4eec\u9700\u8981\u5bf9\u8bfb\u53d6\u7684\u6570\u636e\u8fdb\u884c\u6392\u5e8f\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u4f7f\u7528 MySQL \u7684 ORDER BY \u5b50\u53e5\u6765\u8bbe\u5b9a\u4f60\u60f3\u6309\u54ea\u4e2a\u5b57\u6bb5\u54ea\u79cd\u65b9\u5f0f\u6765\u8fdb\u884c\u6392\u5e8f\uff0c\u518d\u8fd4\u56de\u641c\u7d22\u7ed3\u679c\u3002
\u5177\u4f53\u8bed\u6cd5\u53c2\u8003\uff1a
\u4ee5\u4e0b\u662f SQL SELECT \u8bed\u53e5\u4f7f\u7528 ORDER BY \u5b50\u53e5\u5c06\u67e5\u8be2\u6570\u636e\u6392\u5e8f\u540e\u518d\u8fd4\u56de\u6570\u636e\uff1a
from \u6811\u61d2\u5b66\u5802 - \u4e00\u7ad9\u5f0f\u6570\u636e\u77e5\u8bc6\u5e73\u53f0
\u4f60\u53ef\u4ee5\u4f7f\u7528\u4efb\u4f55\u5b57\u6bb5\u6765\u4f5c\u4e3a\u6392\u5e8f\u7684\u6761\u4ef6\uff0c\u4ece\u800c\u8fd4\u56de\u6392\u5e8f\u540e\u7684\u67e5\u8be2\u7ed3\u679c\u3002
\u4f60\u53ef\u4ee5\u8bbe\u5b9a\u591a\u4e2a\u5b57\u6bb5\u6765\u6392\u5e8f\u3002
\u4f60\u53ef\u4ee5\u4f7f\u7528 ASC \u6216 DESC \u5173\u952e\u5b57\u6765\u8bbe\u7f6e\u67e5\u8be2\u7ed3\u679c\u662f\u6309\u5347\u5e8f\u6216\u964d\u5e8f\u6392\u5217\u3002 \u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0c\u5b83\u662f\u6309\u5347\u5e8f\u6392\u5217\u3002
\u4f60\u53ef\u4ee5\u6dfb\u52a0 WHERE\u2026LIKE \u5b50\u53e5\u6765\u8bbe\u7f6e\u6761\u4ef6\u3002
\u6240\u4ee5\uff0c\u697c\u4e3b\u6240\u95ee\u7684\u95ee\u9898\u7b54\u6848\u5e94\u8be5\u4e3a\uff1aselect ... from ... order by ID desc limit(0,5)
绛旓細1锛夛紝鍒╃敤mysql鑷甫鐨刴ax鍑芥暟鍙栧緱鏈澶у 2锛夛紝鍏堟寜鐓id闄嶅簭鎺掑垪锛岀劧鍚庡埄鐢╨imit鍑芥暟鍙栨渶澶у硷細
绛旓細select count(t.counts) from (select id,count(*) counts from 琛ㄥ悕 group by id) t 杩欐牱寰楀埌鐨勭粨鏋滃氨鏄3銆
绛旓細浣跨敤union鍚с傚厛鏌ュ嚭ID鏈澶х殑涓鏉¤褰曪紝鍐嶆煡鍑篒D涓嶆槸杩欎釜鏈澶у肩殑浜虹殑鍓9鍚嶅叡9鏉¤褰銆俿elect * from tab_A where id in (select max(id) from tabA) union select * from tab_A where id not in (select max(id) from tabA) order by score desc limit 9;鎶妕ab_A鎹㈡垚浣犵殑琛ㄥ悕锛屾妸...
绛旓細鐢細select MAX(id) from table limit 0,1;Mysql涓鏁板瓧绫诲瀷瀛楁鍙洿鎺ヤ娇鐢∕AX()鍑芥暟锛屼娇鐢╩ax鍑芥暟鏌ヨ涓涓瓧绗︿覆绫诲瀷鐨勫瓧娈垫椂锛屽洜涓哄瓧绗︿覆绫诲瀷澶у皬姣旇緝鏄厛姣旇緝棣栧瓧绗︼紝鐒跺悗渚濇寰鍚庤繘琛屾瘮杈 濡傛湁鏁版嵁锛10000,9999銆備娇鐢╩ax鏌鍑烘潵鐨鏈澶у煎苟涓嶆槸10000锛岃屾槸9999 瑙ｅ喅鏂规硶濡備笅锛歮ax(id+0)...
绛旓細濡傛灉鏄垰鍋氳繃鎻掑叆鎿嶄綔鐨勶紝璇曡瘯 last_insert_id()锛屽畠浼氳繑鍥炲垰鎻掕繘鍘婚偅鏉¤褰曠殑 ID锛屾病鏈夊苟鍙戠殑鏃跺欏畠涓鑸槸鏈澶у銆傚彟澶栵紝璇曡瘯 select max(id) from 琛ㄥ悕锛屽彇杩欎釜鏈澶d鏈夋剰涔夊悧锛熷湪骞跺彂鎯呭喌涓嬶紝鏈澶d 鐨勫兼垨璁镐笉鍋滅殑鍦ㄥ彉鍖栫殑銆
绛旓細order by id 鎸夐檷搴忔帓 鍙栧墠鍗
绛旓細SELECT * FROM `table` order by `id` desc limit 0,1
绛旓細1銆佷緥濡備綘鐨 root鐢ㄦ埛鐜板湪娌℃湁瀵嗙爜锛屼綘甯屾湜鐨勫瘑鐮佷慨鏀逛负abc锛岄偅涔堝懡浠ゆ槸锛mysqladmin -u root password abc 2銆佸鏋滀綘鐨剅oot鐜板湪鏈夊瘑鐮佷簡锛岄偅涔堜慨鏀瑰瘑鐮佷负abc鐨勫懡浠ゆ槸锛歮ysqladmin -u root -p password youyou 娉ㄦ剰锛屽懡浠ゅ洖杞﹀悗浼氶棶浣犳棫瀵嗙爜锛岃緭鍏ユ棫瀵嗙爜涔嬪悗鍛戒护瀹屾垚锛屽瘑鐮佷慨鏀规垚鍔熴備簩銆佸瘑鐮佺殑娑堥櫎 1...
绛旓細mysql_select_db("date");result=mysql_query("select max(id+0) max_id from music",$conn);field=mysql_fetch_row($result);print_r($field);?> 缁撴灉锛欰rray ( [0] => 161 )鍥犱负mysql涓varchar涓嶈兘鐢╩ax()鎵浠ラ氳繃id+0鏉ヨ浆鎹d绫诲瀷浠庤岃В鍐宠繖涓棶棰 锛屽鏋滀綘寤鸿〃鏃秈d鏄暣鏁板瀷鐨勫氨鍙互...
绛旓細select max(id) id,nickname,tel,`group`,ali_pid,ad_pid,pid from 琛ㄥ悕 group by nickname,tel,`group`,ali_pid,ad_pid,pid
