Êý¾Ý¿â¼¼Êõ¸´Ï°ÊÔÌâ¼°´ð°¸ ÏÂÔØ±¾ÎÄ

8.ijÉÌÒµ¼¯ÍÅÊý¾Ý¿âÓÐÈý¸öʵÌ弯¡£Ò»ÊÇ¡°ÉÌÆ·¡±ÊµÌ弯£¬ÊôÐÔÓÐÉÌÆ·ºÅ¡¢ÉÌÆ·Ãû¡¢¹æ¸ñ¡¢µ¥¼ÛµÈ£»¶þÊÇ¡°É̵ꡱʵÌ弯£¬ÊôÐÔÓÐÉ̵êºÅ¡¢É̵êÃû¡¢µØÖ·µÈ£»ÈýÊÇ¡°Ö°¹¤¡±ÊµÌ弯£¬ÊôÐÔÓÐÖ°¹¤±àºÅ¡¢ÐÕÃû¡¢ÐÔ±ð¡¢Òµ¼¨µÈ¡£É̵êÓëÖ°¹¤¼ä´æÔÚ¡°Æ¸Óá±ÁªÏµ£¬Ã¿¸öÉ̵êÓÐÐí¶àÖ°¹¤£¬Ã¿¸öÖ°¹¤Ö»ÄÜÔÚÒ»¸öÉ̵깤×÷£¬ÉÌµêÆ¸ÓÃÖ°¹¤ÓÐÆ¸ÆÚºÍÔÂн¡£

(1)ÊÔ»­³ö·´Ó³ÉÏÊöÎÊÌâµÄERͼ£¬²¢ÔÚͼÉÏ×¢Ã÷ÊôÐÔ¡¢ÁªÏµµÄÀàÐÍ¡£ (2)½«ERͼת»¯³É¹ØÏµÄ£ÐÍ£¬²¢×¢Ã÷Ö÷¼üºÍÍâ¼ü¡£ ²Î¿¼½Ì²ÄP81-P100 10.ÈçÏÂÈýÕÅ±í£º

д³öÊʵ±µÄSQLÓï¾ä£¬Íê³ÉÏÂÁи÷Ìâ¡£ 1)£®¶¨Ò塰ѧÉú¡±±íµÄ½á¹¹

2)£®²éѯÄêÁäÔÚ18ÖÁ22Ö®¼äµÄÄÐÉúµÄѧºÅ£¬ÐÕÃû 3)£®½«ËùÓÐѧÉúµÄÄêÁäÔö¼Ó1Ëê

4)£®Í³¼Æ¿Î³Ì¡°Êý¾Ý¿â¼¼Êõ¡±·ÖÊýСÓÚ60·ÖµÄÈËÊý ´ð°¸:1)CREATETABLEѧÉú £¨Ñ§ºÅSMALLINTNOTNULLUNIQUE£¬ ÐÕÃûCHAR£¨8£©NOTNULL£¬ ÐÔ±ðCHAR£¨2£©£¬ ÄêÁäSMALLINT£¬ PRIMARYKEY£¨Ñ§ºÅ£©£©£» 2£©SELECTѧºÅ£¬ÐÕÃû FROMѧÉú

WHEREÄêÁäBETWEEN18AND22£» 3£©UPDATEѧÉú

SETÄêÁä=ÄêÁä+1£» 4£©SELECTCOUNT£¨Ñ§ºÅ£© FROM¿Î³Ì£¬³É¼¨

WHERE¿Î³Ì.¿Î³ÌºÅ=³É¼¨.¿Î³ÌºÅAND¿Î³ÌÃû³Æ=¡¯Êý¾Ý¼¼Êõ¡¯AND·ÖÊý<60;