mysql对查询结果进行升序排序的关键字是
ASC。mysql对查询结果系统默认的是升序排列,升序排序的关键字是ASC,降序的关键字是DESC。关键是一个汉语词汇,意思是对事物最紧要的部分,在一段时间内,对事物起决定性作用。绛旓細ASC銆俶ysql瀵规煡璇㈢粨鏋滅郴缁熼粯璁ょ殑鏄崌搴忔帓鍒楋紝鍗囧簭鎺掑簭鐨勫叧閿瓧鏄疉SC锛岄檷搴忕殑鍏抽敭瀛楁槸DESC銆傚叧閿槸涓涓眽璇瘝姹囷紝鎰忔濇槸瀵逛簨鐗╂渶绱ц鐨勯儴鍒嗭紝鍦ㄤ竴娈垫椂闂村唴锛屽浜嬬墿璧峰喅瀹氭т綔鐢ㄣ
绛旓細鍦ㄦ墽琛屾煡璇㈢粨鏋滄椂锛岄粯璁ゆ儏鍐典笅鏌ヨ缁撴灉鏃犲簭鎺掑垪銆備絾鎴戜滑鏈夋椂闇瑕佸鏁版嵁鎸変竴瀹氳鍒欒繘琛屾帓搴忋傝繖鏃跺彲浠ラ氳繃ORDER BY瀛愬彞鏉ュ疄鐜拌繖涓姛鑳姐傝娉曞涓嬶細SELECT <*,column [alias],...> FROM table [WHERE condition(s)][ORDER BY column[ASC|DESC]]锛涢粯璁ゆ槸ASC鎸囧畾鐨勫崌搴忔帓鍒楋紝DESC鐢ㄦ潵鎸囧畾闄嶅簭鎺掑垪銆1銆佸崌搴...
绛旓細2013-05-23 SQL鏁版嵁搴:鏌ヨ璇剧▼鍙蜂负鈥203402鈥濈殑鎴愮哗鏈楂樼殑鍓5鍚... 10 2015-12-21 鏌ヨ姣忛棬璇剧▼鐨勫钩鍧囨垚缁,缁撴灉鎸骞冲潎鎴愮哗鍗囧簭鎺掑垪,骞冲潎鎴愮哗鐩稿悓... 3 2012-11-03 SQL璇彞鐨勪竴閬撻 涓変釜鍩烘湰琛:瀛︾敓琛(Student)銆佽... 117 2012-01-03 楹荤儲璇锋暀鍚勪綅楂樻墜涓浜MYSQL鏁版嵁搴撶殑闂? 2013-05-04 寤虹珛...
绛旓細- 褰撴帓搴忕殑瀛楁涓瓨鍦ㄧ┖鍊兼椂锛孫RDER BY 浼氬皢璇ョ┖鍊间綔涓烘渶灏忓兼潵瀵瑰緟鏌ヨ鏁版嵁鎸夊瓧姣鍗囧簭杩涜鎺掑簭锛圓 Z锛夛紝浣嗘暟鎹殑鎺掑簭骞朵笉浠呴檺浜庢锛岃繕鍙互浣跨敤 ORDER BY 涓殑 DESC 瀵规煡璇㈢粨鏋滆繘琛闄嶅簭鎺掑簭锛圸 A锛夈傛潯浠舵煡璇㈡暟鎹 WHERE 濡傛灉闇瑕佹湁鏉′欢鐨勪粠鏁版嵁琛ㄤ腑鏌ヨ鏁版嵁锛屽彲浠ヤ娇鐢 WHERE 鍏抽敭瀛楁潵鎸囧畾鏌ヨ...
绛旓細ASC鏄鍗囧簭鎺掑垪锛屽叾瀹為粯璁ゅ氨鏄崌搴忔帓鍒椼
绛旓細MySQL鐨鎺掑簭锛屼娇鐢╫rder by鏉ュ疄鐜般俹rder by id asc锛岃〃绀虹敤id鍗囧簭鎺掑垪 order by id desc锛岃〃绀虹敤id闄嶅簭鎺掑垪 褰撻渶瑕佺敤澶氫釜瀛楁鎺掑簭鏃讹紝order by cdate desc锛宨d asc锛岃〃绀哄厛鐢╟date闄嶅簭鎺掑垪锛宑date鐩稿悓鐨勫啀鐢╥d鍗囧簭鎺掑垪
绛旓細mysql榛樿鏄鍗囧簭銆俶ysql_num_rows鏄疨HP璇█鐨涓殑鍑芥暟锛屽叾琛ㄧず鍙栧緱缁撴灉闆嗕腑琛岀殑鏁扮洰銆傛鍛戒护鍙SELECT璇彞鏈夋晥銆傝鍙栧緱琚 INSERT锛孶PDATE 鎴朌ELETE 鏌ヨ鎵褰卞搷鍒扮殑琛岀殑鏁扮洰锛岀敤 mysql_affected_rows()銆侾HP锛堝鏂囧悕锛歅HP锛欻ypertext Preprocessor锛屼腑鏂囧悕锛氣滆秴鏂囨湰棰勫鐞嗗櫒鈥濓級鏄竴绉嶉氱敤寮婧愯剼鏈瑷銆傝...
绛旓細asc 鏄痑scend 鍗囧簭鎰忔 sql = "select 琛ㄥ唴瀹瑰悕 from 鏁版嵁搴撹〃鍚 Putout=true order by 璇诲彇鐨鎺掑簭琛ㄥ悕 asc"渚嬪 sql = "select * from user where Putout=true order by time desc" //鎸鏈鏂版椂闂存潵鎺掑簭 sql = "select * from user where Putout=true...
绛旓細Mysql閲岄潰榛樿鎺掑簭鏄鍗囧簭銆侽RDER BY 瀛愬彞鑻ユ湭鏄惧紡鎸囧畾鍗囧簭(ASC)鎴栭檷搴(DESC)锛岄偅涔堝氨璁鎸榛樿鍗囧簭鎺掑簭銆
绛旓細鐗圭偣锛 1銆乤sc浠h〃鐨鏄鍗囧簭锛屽彲浠ョ渷鐣 desc浠h〃鐨勬槸闄嶅簭 2銆乷rder by瀛愬彞鍙互鏀寔 鍗曚釜瀛楁銆佸埆鍚嶃佽〃杈惧紡銆佸嚱鏁般佸涓瓧娈 3銆乷rder by瀛愬彞鍦鏌ヨ璇彞鐨勬渶鍚庨潰锛岄櫎浜唋imit瀛愬彞 / SELECT * FROM employees ORDER BY salary DESC;SELECT * FROM employees WHERE department_id>=90 ORDER ...