Èí¼þ²âÊÔÖг£ÓõÄ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;
Ïà¹ØÎĵµ£º
²éѯ card µÄ¼Ç¼ΪÁ½´ÎÒÔÉ쵀 card£¬¼Ç¼Êý:
select count(card), card from TableName group by card having count(card) > 1
¼¶Áª¸üУ¬¼¶ÁªÉ¾³ý:
ColumnName type not null constraint FK_Name foreign key(ColumnName) references PrimaryTable(ColumnName) on update/delete cascade
×Ô¶¯¼ÆËãÁÐ:
create tabl ......
×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈ˰¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......
¾µäSQLÓï¾ä´óÈ«
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡ ......
ÎÊÌ⣺
ÓÐÒ»¸ö·ÖÊý±í
id classid,score
1 01 120
2 01 128
3 02 98
4 04 134
5 04 78
ÏÖÔÚҪͳ¼Æ ¸÷°àscore >120,ºÍ´óÓÚ90·ÖµÄÈËÊý
´ïµ½ÈçÏÂЧ¹û
classid >120 >90
01 &nb ......
SQL ServerÔÚ°²×°µ½·þÎñÆ÷ÉϺó£¬ÓÉÓÚ³öÓÚ·þÎñÆ÷°²È«µÄÐèÒª£¬ËùÒÔÐèÒªÆÁ±ÎµôËùÓв»Ê¹ÓõĶ˿ڣ¬Ö»¿ª·Å±ØÐëʹÓõĶ˿ڡ£ÏÂÃæ¾ÍÀ´½éÉÜÏÂSQL Server 2008ÖÐʹÓõĶ˿ÚÓÐÄÄЩ£º
Ê×ÏÈ£¬×î³£ÓÃ×î³£¼ûµÄ¾ÍÊÇ1433¶Ë¿Ú¡£Õâ¸öÊÇÊý¾Ý¿âÒýÇæµÄ¶Ë¿Ú£¬Èç¹ûÎÒÃÇÒªÔ¶³ÌÁ¬½ÓÊý¾Ý¿âÒýÇæ£¬ÄÇô¾ÍÐèÒª´ò¿ª¸Ã¶Ë¿Ú¡£Õâ¸ö¶Ë¿ÚÊÇ¿ÉÒÔÐ޸ĵģ¬ÔÚ&ldqu ......