SQL
鏌ヨ璇彞澶у叏闆嗛敠
MYSQL
鏌ヨ璇彞澶у叏闆嗛敠
涓�銆?/p>
绠�鍗曟煡璇?/p>
绠�鍗曠殑
Transact-SQL
鏌ヨ鍙寘鎷�夋嫨鍒楄〃銆?/p>
FROM
瀛愬彞鍜?/p>
WHERE
瀛愬彞銆傚畠浠垎鍒鏄庢墍鏌ヨ鍒椼�佹煡璇㈢殑
琛ㄦ垨瑙嗗浘銆佷互鍙婃悳绱㈡潯浠剁瓑銆?/p>
渚嬪锛屼笅闈㈢殑璇彞鏌ヨ
testtable
琛ㄤ腑濮撳悕涓衡�滃紶涓夆�濈殑
nickname
瀛楁鍜?/p>
瀛楁銆?/p>
澶嶅埗鍐呭鍒板壀璐存澘
浠ｇ爜
:SELECT `nickname`,`email`FROM `testtable`WHERE `name`='
寮犱笁
'
(
涓�
)
閫夋嫨鍒楄〃
閫夋嫨鍒楄〃
(select_list)
鎸囧嚭鎵�鏌ヨ鍒楋紝瀹冨彲浠ユ槸涓�缁勫垪鍚嶅垪琛ㄣ�佹槦鍙枫�佽〃杈惧紡銆佸彉閲?/p>
(
鍖呮嫭灞�閮ㄥ彉閲忓拰鍏ㄥ眬鍙橀噺
)
绛夋瀯鎴愩�?/p>
1
銆侀�夋嫨鎵�鏈夊垪
渚嬪锛屼笅闈㈣鍙ユ樉绀?/p>
testtable
琛ㄤ腑鎵�鏈夊垪鐨勬暟鎹細
澶嶅埗鍐呭鍒板壀璐存澘
浠ｇ爜
:SELECT * FROM testtable
2
銆侀�夋嫨閮ㄥ垎鍒楀苟鎸囧畾瀹冧滑鐨勬樉绀烘搴?/p>
鏌ヨ缁撴灉闆嗗悎涓暟鎹殑鎺掑垪椤哄簭涓庨�夋嫨鍒楄〃涓墍鎸囧畾鐨勫垪鍚嶆帓鍒楅『搴忕浉鍚屻�?/p>
渚嬪锛?/p>
澶嶅埗鍐呭鍒板壀璐存澘
浠ｇ爜
:SELECT nickname,email FROM testtable
3
銆佹洿鏀瑰垪鏍囬
鍦ㄩ�夋嫨鍒楄〃涓紝鍙噸鏂版寚瀹氬垪鏍囬銆傚畾涔夋牸寮忎负锛?/p>
鍒楁爣棰?/p>
=
鍒楀悕
鍒楀悕
鍒楁爣棰?/p>
濡傛灉鎸囧畾鐨勫垪鏍囬涓嶆槸鏍囧噯鐨勬爣璇嗙鏍煎紡鏃讹紝搴斾娇鐢ㄥ紩鍙峰畾鐣岀锛屼緥濡傦紝涓嬪垪璇彞浣跨敤姹夊瓧鏄剧ず鍒?/p>
鏍囬锛?/p>