Èí¼þ²âÊÔÖг£ÓõÄSQLÓï¾ä

²éѯÓï¾ä
Óï·¨¸ñʽ£º
SELECT
    [ALL | DISTINCT | DISTINCTROW ]
      [HIGH_PRIORITY]
      [STRAIGHT_JOIN]
      [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_
      [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUN
    select_expr [, select_expr ...]
    [from table_references
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}
      [ASC | DESC], ... [WITH ROLLUP]]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC], ...]
    [LIMIT {[offset,] row_count | row_count OFF
    [PROCEDURE procedure_name(argument_list)]
    [INTO OUTFILE 'file_name' export_options
      | INTO DUMPFILE 'file_name'
      | INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]
³£ÓþÙÀý
--²éѯmember±íÖÐËùÓеĻáÔ±¼Ç¼
SELECT * from member;
ÆäÖГ*”ºÅ±íʾÏÔʾ·ûºÏÌõ¼þµÄ¼Ç¼µÄËùÓÐ×Ö¶Î
ÔÚÊý¾Ý¿âÖд洢ÀàÐÍΪÎı¾µÄ×ֶβéѯ
--²éѯmember±íÖÐÐÕÃû½ÐÕÅÈýµÄ»áÔ±
SELECT * from member WHERE name = 'ÕÅÈý';
--²éѯmember±íÖÐËùÓÐÐÕÕŵĻáÔ±
SELECT * from member WHERE name like ‘ÕÅ%’;
ÆäÖГ%”±íʾÈÎÒâ×Ö·û¶¼·ûºÏÌõ¼þ¡£¼´Ö»ÓÐÂú×ãÐÕÃûÖеÚ1¸ö×Ö·ûÊÇ“ÕÅ”¾ÍÂú×ã²éѯÌõ¼þ
--²éѯmember±íÖÐËùÓÐÃû×Ö°üº¬“Èý”µÄ»áÔ±
SELECT * from member WHERE name like ‘%Èý%’;
ÓÉÓÚ“Èý”×ÖÇ°ºó¶¼º¬Óаٷֺœ%”£¬Õâ¾Í±íʾ“Èý”×ÖÇ°ÃæºÍ“Èý”×ÖºóÃæ²»¹ÜÊÇÈκÎ×Ö·û¶¼Âú×ã²éѯÌõ¼þ£¬¼´Ê¹“Èý”×ÖÇ°ºóûÓÐ×Ö·ûÒ²·ûºÏÌõ¼þ
ÔÚÊý¾Ý¿âÖÐÄêÁä´æ´¢ÎªÊý×ÖÀàÐ͵Ä×ֶβéѯ
--²éѯmember±íÖÐÄêÁäµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age = 18;
--²éѯmember±íÖÐÄêÁä´óÓÚµÈÓÚ18µÄ»áÔ±
SELECT * from member WHERE age >= 18;