µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
PHP
»
PHP+MySQL ¤Jªù¹ê§@
» 8-2-4 Limit ¨îµ§¼Æ
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
8-2-4 Limit ¨îµ§¼Æ
¤p»x
µoµu®ø®§
¥[¬°¦n¤Í
¤p»x
(¤p»x)
·í«eÂ÷½u
´¿¸g¤]¬O¤ô¹q¤u
UID
9
©«¤l
1190
¥DÃD
394
ºëµØ
113
¿n¤À
1747
ª÷¿ú
1747
ÂI¦W
1
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2003
¾\ŪÅv
200
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
490 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2024-11-25
¡@¼ÊºÙ:
¤p»x
¡@ÀY»Î:
´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
©«¤l
1190
¥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-11-25
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2011-4-20 10:33
|
¥u¬Ý¸Ó§@ªÌ
8-2-4 Limit ¨îµ§¼Æ
8-2-4 Limit ¨îµ§¼Æ
¦Ñ®v»¡¡G¥»¦¸¦Ò¸Õ¦¨ÁZ¡AÁ`¤À¬°¥þ¯Z«e¤¦WªÌ¡A¥iÀò±o¼ú¾Çª÷¡I²{¦b½Ð±z±N¡u¦¨ÁZ³æ¡v¸ê®Æªí¤ºÁ`¤À¬°«e¤¦Wªº¦P¾Ç¦Cªí¥X¨Ó¡A³oÓSQL«ü¥O¦p¦ó¤U¡H¥ý§âÁ`¦¨ÁZpºâ¥X¨Ó©ñ¦b¦Ûq¦WºÙªº¡uÁ`¤À¡vÄæ¦ì¸Ì¡G
Select ©m¦W,°ê¤å,^¤å,¼Æ¾Ç,°ê¤å+^¤å+¼Æ¾Ç As Á`¤À From transcript
½Æ»s¥N½X
µM«á¡A¦A¥[¤J¨Ì·ÓÁ`¤À±Æ§Çªº«ü¥O¡G
Select ©m¦W,°ê¤å,^¤å,¼Æ¾Ç,°ê¤å+^¤å+¼Æ¾Ç As Á`¤À From transcript Order By Á`¤À
½Æ»s¥N½X
¬O¨Ì·ÓÁ`¤À±Æ§Ç¤F¨S¿ù¡A¦ý«o¬O¥Ñ³Ì§C¤À¼Æ±Æ¨ì³Ì°ª¤À¼Æ¡A±o¼úªº¥i¤£¬O˼ƫe¤¦Wªº¦P¾Ç£«¡I¦Ó¬On¤À¼Æ³Ì°ªªº«e¤¦W¦P¾Ç¡A¦]¦¹¡An¦b±Æ§ÇÄæ¦ì¦WºÙ¡]°ê¤å+^¤å+¼Æ¾Ç¡^ªº«á±¦A¥[¤W¡uDesc¡v«ü¥O¡AÅý±Æ§Çªºµ²ªG¬O¡u±q¤j±Æ¨ì¤p¡v¡G
Select ©m¦W,°ê¤å,^¤å,¼Æ¾Ç, °ê¤å+^¤å+¼Æ¾Ç As Á`¤À From transcript Order ByÁ`¤À
½Æ»s¥N½X
¤W¦¡SQL«ü¥O¥iÀò±o¤U¹Ïµ²ªG¡G¡]½d¨Òex08_19.php¡^
¤U¸ü
(28.99 KB)
2011-4-20 10:33
¹Ï8-21 ¨Ì¡uÁ`¤À±Æ§Ç¡v±q¤j±Æ¨ì¤p¡C
¼Ó¥D¼ö©«
½×¾Â¤£Åý¸ê¾ú¤ñ¸û²Lªº¤H¤U¸ü¬d¬Ýªþ¥óªº¥Î·N
EXCEL±MÄÝ°Q½×°Ï¦Û§Y¤é°_¤¤¾Ç¥Í¥H¤W·|û¤è
³Â»¶®a±Ú°Q½×°Ï ³q¥Îª©³W
OFFICE °ò¦±Ð¾Ç¼Æ¦ì¤Æ
ATX ¹q·½¨ÑÀ³¾¹¤â°Ê±Ò°Ê(¤£±µ¥D¾÷ªO±Ò°Ê)
¦Ò¼{Ãö³¬½×¾Âºô¯¸
³Â»¶®a±Ú°Q½×°ÏÁô¨pÅv¬Fµ¦»¡©ú
³Â»¶®a±Ú°Q½×°Ï ¸Û¼xª©¥D
¥Ñ½׾ÂÂà¶iªº¤¤¾Ç¥Íµ¥¯Å¥H¤W·|û,½ÐÃöª`!
14-2 ¸ê®Æ®w¹Ï¤ù¦s¨ú
¦¬ÂÃ
¤À¨É
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
¤p»x
µoµu®ø®§
¥[¬°¦n¤Í
¤p»x
(¤p»x)
·í«eÂ÷½u
´¿¸g¤]¬O¤ô¹q¤u
UID
9
©«¤l
1190
¥DÃD
394
ºëµØ
113
¿n¤À
1747
ª÷¿ú
1747
ÂI¦W
1
§@·~¨t²Î
Vista
³nÅ骩¥»
Office 2003
¾\ŪÅv
200
©Ê§O
¨k
¨Ó¦Û
¥xÆW
¦b½u®É¶¡
490 ¤p®É
µù¥U®É¶¡
2010-5-1
³Ì«áµn¿ý
2024-11-25
¡@¼ÊºÙ:
¤p»x
¡@ÀY»Î:
´¿¸g¤]¬O¤ô¹q¤u
ºÞ²zû
©«¤l
1190
¥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-11-25
2
#
µoªí©ó 2011-4-20 10:36
|
¥u¬Ý¸Ó§@ªÌ
Ok¡I¥Ñ¤À¼Æ°ªªº±Æ¨ì¤À¼Æ§Cªº¤F¡A¦ý¬O§ÚÌ¥u¨ú«e¤¦W£«¡A©Ò¥H¦Cªíªºµ²ªG¥u»ÝÅã¥ÜÁ`¤À¬°«e¤¦Wªº¦P¾Ç¸ê®Æ¡A³o®ÉÔ§ÚÌ´N¥i¥H¨Ï¥Î¡uLimit¡v«ü¥O¡A±Nì¨Óªº¡uSelect¡KDesc¡v§ó§ï¬°¡uSelect¡KDesc Limit¡v¡A¨Ã¦b¡uLimit¡v¤§«á«ü©w§ÚÌn¿ï¨úªºµ§¼Æ§Y¥i¡G¡]½d¨Òex08_20.php¡^
Select ©m¦W,°ê¤å,^¤å,¼Æ¾Ç, °ê¤å+^¤å+¼Æ¾Ç As Á`¤À From transcript Order ByÁ`¤ÀDesc Limit 5
½Æ»s¥N½X
³o¼Ë´NÀò±o¥¿½Tªºµ²ªGÅo¡I¦p¤U¹Ï©Ò¥Ü¡G
¤U¸ü
(22.18 KB)
2011-4-20 10:35
¹Ï8-23 SQL«ü¥O°õ¦æµ²ªG¡C
¤ß¦w¡A¥¦w
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!
TOP
ÀR«ä¦Û¦b :
¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·