9-1 »{ÃÑDML«ü¥O(9-1-1 Select«ü¥O)
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
9-1 »{ÃÑDML«ü¥O(9-1-1 Select«ü¥O)
9-1 »{ÃÑDML«ü¥O
DML¡G¸ê®Æ³B²z»y¨¥¡A¬°SQL¤¤ªº¸ê®Æ³B²z«ü¥O¸s¡A¥]¬ASelect¡]¬d¸ß¡^¡BInsert¡]·s¼W¡^¡BDelete¡]§R°£¡^¡BUpdate¡]קï¡^µ¥«ü¥O¡C
9-1-1 Select«ü¥O
Select«ü¥O±z¤£¯¥Í§a¡I¦b¤W¤@³¹¤¤¡Aµ§ªÌ´N°µ¤F«Ü¦hªº¤¶²Ð¡A²{¦bµ§ªÌn¤¶²Ðªº¬OSelect«ü¥Oªº¶i¶¥À³¥Î¡G
¸ó¸ê®Æªí¬d¸ß
µ§ªÌ²{¦bÁ|¤@Ó¹ê¨Ò¨Ó»¡©ú¡G¦bLEAVE¸ê®Æ®w¤¤§t¦³¡ufactoryman¡]û¤u¦W³æ¡^¡v¡B¡ulaik¡]¥ð°²°O¿ý¡^¡v³o¨âÓ¸ê®Æªí¡G
¹Ï9-1 ½d¨Ò¸ê®Æ®w¤ºªº¸ê®Æªí¡C
²{¦b§Ún±q¡ufactoryman¡]û¤u¦W³æ¡^¡v¸ê®Æªí¤¤¬D¥X¡ulaik¡]¥ð°²°O¿ý¡^¡v¸ê®Æªí¤º¥ð°²¡u¤Ñ¼Æ¡v¤j©ó¤T¤Ñªºû¤u¸ê®Æ¡A¦pªG³æ¯Âªº¨Ï¥Î¤@ÓSelect«ü¥O¬OµLªk¹F¨ì³oÓn¨Dªº¡A¦]¦¹§ÚÌ¥²¶·¨Ï¥Î¨âÓSelect«ü¥O¡Iº¥ý§ÚÌ¥ý§Q¥Î¤U¦C±Ôz§ä¥X¡ulaik¡]¥ð°²°O¿ý¡^¡v¸ê®Æªí¤º¥ð°²¡u¤Ñ¼Æ¡v¤j©ó¤T¤Ñªºû¤u¸ê®Æ¡G- Select ©m¦W From laik Where ¤Ñ¼Æ>3
½Æ»s¥N½X ³o¼Ëªº¬d¸ßµ²ªG´N¦¨¬°¤@Ó¡uµêÀÀ¡v¸ê®Æªí¡]¶°¡^¡A±µµÛ§ÚÌn§Q¥Î³oÓ¡uµêÀÀ¡v¸ê®Æªí¡]¶°¡^ªº¸ê®Æ¬°¶i¶¥¿z¿ï±ø¥óÈ¡A¿z¿ï¥X¡ufactoryman¡]û¤u¦W³æ¡^¡v¸ê®Æªí¤¤³QÂI¦W¥ð°²¶W¹L3¤Ñªºû¤u¸ê®Æ¡G- Select * From factoryman where ©m¦W In
- (Select ©m¦W From laik Where ¤Ñ¼Æ>3)
½Æ»s¥N½X ¦p¦¹¡A´N¥i¥H±q¡uû¤u¦W³æ¡v¸ê®Æªí¤¤¬D¥X¡u¥ð°²°O¿ý¡v¸ê®Æªí¤º¥ð°²¡u¤Ñ¼Æ¡v¤j©ó¤T¤Ñªºû¤u¸ê®Æ¡I
¹Ï9-2 SubQuery¡C
¤W¹Ï¤¤¡G¥¼¥[®Ø³¡¤ÀªºSelect«ü¥O±Ôz¤¤§t¦³¥t¤@¬q³Q®Ø½u®Ø°_¨ÓªºSelect«ü¥O±Ôz¡A³oºØÂùSelect«ü¥O²Õ¦Xªº±ÔzºÙ¤§¬°¡uSubQuery¡v¡I |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
·í§Ú̱N³o¡u¶i¶¥¬d¸ß«ü¥O¡vÀ³¥Î©óµ{¦¡¤¤±N¥i±o¨ì¹Ï9-3ªºµ²ªG¡A³Q±ø¦C¥X¨Óªºû¤u³£¬O¥ð°²¤Ñ¼Æ¶W¹L¤T¤ÑªÌ¡C
ex09_01.php- <?
- $conn = mysql_connect("localhost", "root", "12345a");
- if(@mysql_select_db("LEAVE", $conn))
- {
- //«ü©w´£¨ú¸ê®Æªº®Õ¹ï¦r¤¸ªí
- mysql_query("set character set big5");
- //¸ê®Æ®w¦s¦b,«Ø¥ßSQL©R¥O¦r¦ê
- $SQL="Select * From Factoryman where ©m¦W In" .
- "(Select ©m¦W From laik Where ¤Ñ¼Æ>3)"; //±N¦^¶Çµ²ªG¦s©ñ©óÅܼƤ¤
- $datalist=mysql_query($SQL);
- //¨ú±oÄæ¦ì¼Æ¶q
- $fieldnum=mysql_num_fields($datalist);
- ?>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=big5">
- <title>½d¨Òex09_01</title>
- </head>
- <center><table border=1 width=100%>
- <?
- /**************¦C¥XÄæ¦ì©ïÀY***************/
- echo "<tr>";
- for ($x=0 ;$x<$fieldnum;$x++)
- {
- echo "<td>" . mysql_field_name($datalist,$x) . "</td>";
- }
- echo "</tr>";
- /**************¦C¥XÄæ¦ì¸ê®Æ***************/
- //±N¸ê®Æ¿ýÂà´«¬°Äæ¦ì°}¦C¶°¦X
- while ($fielddatas=mysql_fetch_array($datalist))
- {
- //¿é¥XÄæ¦ì¸ê®Æ
- echo "<tr>";
- for ($x=0;$x<$fieldnum;$x++)
- {
- echo "<td>" . $fielddatas[$x] . "</td>";
- }
- echo "</tr>";
- }
- ?>
- <table></body>
- </html>
- <?
- }
- else
- {
- echo "¸ê®Æ®w¤£¦s¦b";
- }
- ?>
½Æ»s¥N½X
¹Ï9-3 ½d¨Òex09_01.php¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
¤À²Õ²Îp Group By
¦b¡ulaik¡v¸ê®Æªí¤º¡A§ÚÌ¥i¥Hµo²{û¤u¥ð°²ªº¦¸¼Æ¥i¯à¤£¥u¤@¦¸¡A¤]³\½Ð¤F¤@¦¸¯f°²¡A¹L¤F´X¤Ñ¤S½Ð¤F¨Æ°²¡A¦]¦¹¥ð°²ªº°O¿ý´N¤£¥u¤@¦¸¡G
¹Ï9-4 ¦h¦¸¥ð°²°O¿ý¡C
¦pªG§Ú̧Ʊæ±oª¾û¤uªºÁ`¥ð°²¤Ñ¼Æ¨º§ÚÌ¥i¥H¨Ï¥Î¡uSUM¡v¨ç¼Æ¨Ó²Îp¡G- Select Sum(¤Ñ¼Æ) AS û¤u¥ð°²Á`¤Ñ¼Æ From laik
½Æ»s¥N½X ¥i¬O§Ú̱o¨ìªº¬O¥þ³¡û¤uªº¥ð°²¤Ñ¼Æ£«¡A¨º§Ú§Æ±æ¤À§O±oª¾¨C¤@¦ìû¤uªºÁ`¥ð°²¤Ñ¼Æ¡A¨º¤S§ï¦p¦ó³B²z¡H³oÓ®ÉÔ§ÚÌ´N¥i¥H§Q¥Î¡uGroup By¡v«ü¥O¨Ó¶i¦æ¤À²Õ²Îp¡G- Select ©m¦W,Sum(¤Ñ¼Æ) AS ¥ð°²Á`¤Ñ¼Æ From laik Group By ©m¦W
½Æ»s¥N½X °õ¦æ¤W¦Cªº«ü¥O±Ôz«á¡Aµ²ªG¦p¤U¹Ï¡]½d¨Òex09_02.php¡^¡G
¹Ï9-5 ¤À²Õ²Îp¤§°õ¦æµe±¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
¤À²Õ²Îp¨Ã¤£©w¨Ï¥Î©ó³æ¤@Äæ¦ì¡A¸ê®Æªí¤¤ªº¨C¤@ÓÄæ¦ì³£¥i¦¨¬°¤À²Õªº¨Ì¾Ú¡A¦P®É¡A§Ṳ́]¥i¥H¨Ï¥Î¦hÓÄæ¦ì¨Ó§@¬°¤À²Õªº¨Ì¾Ú¡A¨Ò¦p¤U¦Cªº¤À²Õ«ü¥O±Ôz¡G
¹Ï9-6 ¦hÄæ¤À²Õ¡C
¹Ï9-7 ½d¨Òex09_03.php¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
¤À²Õ¿z¿ï
Group By«ü¥O¤F¥i¥H¥Î¨Ó±Æ§Ç¥~¡A¤]¥i¥H¦P®É¥[¤W±Æ§Ç«ü¥O¨Ó¶i¦æ¸ê®Æ±Æ§Ç¡A¨Ò¦p¡G§ÚÌ¥H¡u°²§O¡v¬°¤À²Õ¨Ì¾Ú¡A§Q¥ÎOrder By«ü¥O°w¹ï¥ð°²¤Ñ¼Æ¨Ó±Æ§Ç¡G- Select °²§O,Sum(¤Ñ¼Æ) AS ¥ð°²Á`¤Ñ¼Æ From laik Group By°²§O Order By¥ð°²Á`¤Ñ¼Æ
½Æ»s¥N½X °£¤F±Æ§Ç¤§¥~¡A§ÚÌÁÙ¥i¥[¤WWhere«ü¥O¥ý¶i¦æ¸ê®Æ¿z¿ï«á¦A¶i¦æ¤À²Õ»P±Æ§Ç¡G- Select °²§O,Sum(¤Ñ¼Æ) AS ¥ð°²Á`¤Ñ¼Æ From laik Where
- ¦~=86 Group By°²§O Order By¥ð°²Á`¤Ñ¼Æ
½Æ»s¥N½X ¤W¨â¦¡ªº±Ôz°õ¦æµ²ªG¦p¹Ï9-8¡An¯S§Oª`·N¨ì¤@ÂI¡G¨Ï¥ÎWhere«ü¥O¶i¦æ¿z¿ï¡A¥u¯à°÷¦bì©l¸ê®Æªº±¡ªp¤U¶i¦æ¿z¿ïªº°Ê§@¡A¤]´N¬O»¡¡A¿z¿ï¸ê®Æªº°Ê§@¥²¶·µo¥Í©ó¤À²Õ°Ê§@¤§«e¡A¤£¯à¦b¤À²Õ°Ê§@§¹¦¨¤§«á¤~¨Ï¥ÎWhere«ü¥O¶i¦æ¤À²Õµ²ªGªº¿z¿ï¡I
¹Ï9-8 ¹Ï¥ª¬°¤À²Õ»P±Æ§Ç¡F¹Ï¥k¬°¸ê®Æ¿z¿ï«á¦A¶i¦æ¤À²Õ»P±Æ§Ç¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
¦b¤À²Õ°Ê§@§¹¦¨¤§«á¡A§ÚÌÁÙn¹ï¤À²Õµ²ªGªº¸ê®Æ¶i¦æ¿z¿ï®É¡A§Ú̸Ӧp¦ó³B²z¡H¤Á°O¡G¤£¯à¨Ï¥ÎWhere«ü¥O¡I§_«h±z·|¨£¨ì¤U¦Cªº¿ù»~°T®§¡G
¹Ï9-9 Where¿z¿ï¤£¯à¦b¤À²Õ§¹¦¨¤§«á¡C
¦pªG¦b¤À²Õ°Ê§@§¹¦¨¤§«á¤~¶i¦æ¸ê®Æ¿z¿ïªº°Ê§@¥²¶·¨Ï¥Î¡uHaving¡v«ü¥O¡A¨Ò¦p¤U¨Ò¡G¡]½d¨Òex09_04.php¡^- //¸ê®Æ®w¦s¦b,«Ø¥ßSQL©R¥O¦r¦ê
- $SQL="Select ¦~,©m¦W,°²§O,sum(¤Ñ¼Æ) AS ¦~¥ð°²¼Æ From laik " .
- "Group By ¦~,©m¦W,°²§O HAVING ¦~=86";
- //±N¦^¶Çµ²ªG¦s©ñ©óÅܼƤ¤
- $datalist=mysql_query($SQL);
- //¨ú±oÄæ¦ì¼Æ¶q
- $fieldnum=mysql_num_fields($datalist);
½Æ»s¥N½X
¹Ï9-10 ¨Ï¥ÎHaving«ü¥O¿z¿ï¤À²Õµ²ªG¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|
¡@¼ÊºÙ: ¤p»x ¡@ÀY»Î: ´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
- ©«¤l
- 1176
- ¥DÃD
- 394
- ºëµØ
- 113
- ¿n¤À
- 1747
- ÂI¦W
- 1
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- Office 2003
- ¾\ŪÅv
- 200
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2024-3-19
|
¨º§Ú¥i¤£¥i¥H§ó§ï¿z¿ïªº±ø¥óÈ¡H¥i¥H¡A±z¤£¦ý¥i¥H¨Ï¥Î¡uµêÀÀ¡vÄæ¦ì¬°¿z¿ïªº®Ú¾Ú¡A¦p¤U¨Ò¡G- Select ¦~,©m¦W,°²§O,sum(¤Ñ¼Æ) AS ¦~¥ð°²¼Æ From ¥ð°²°O¿ý
- Group By ¦~,©m¦W,°²§O Having ¦~¥ð°²¼Æ>2
½Æ»s¥N½X ¤W¦¡¤¤ªº¡u¦~¥ð°²¼Æ¡vÁöµM¬O¡uSum(¤Ñ¼Æ)¡vªºpºâµ²ªG¡A¥¦¤]¬O¤@Ó¡uµêÀÀ¡vÄæ¦ì¡A¤£¬O¸ê®Æ®w¤¤ªº¯u¹êÄæ¦ì¡A¦ý¬O«o¯à¥Î¨Ó°µ¬°¿z¿ïªº®Ú¾Ú¡C
¦pªG±zn¨Ï¥Î¡upºâ¡vÄæ¦ì°µ¬°¿z¿ï®Ú¾Ú¡A¤]¥i¥H¼¶¼g¦¨¤U¦¡¡G¡]½d¨Òex09_05.php¡^- SQL="Select ¦~,©m¦W,°²§O,sum(¤Ñ¼Æ) AS ¦~¥ð°²¼Æ From ¥ð°²°O¿ý " &_
- "Group By ¦~,©m¦W,°²§O Having sum(¤Ñ¼Æ)>2"
- CMD.CommandText=SQL
½Æ»s¥N½X °õ¦æµ²ªG¦p¤U¹Ï¡G
¹Ï9-11 ½d¨Òex09_05.php¡C |
|
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
|
|
|
|
|