µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
PHP
»
PHP+MySQL ¤Jªù¹ê§@
» ²Ä9³¹ SQL«ü¥O»PPHP
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[±Ð¾Ç]
²Ä9³¹ SQL«ü¥O»PPHP
¤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-21 18:45
|
¥u¬Ý¸Ó§@ªÌ
[±Ð¾Ç]
²Ä9³¹ SQL«ü¥O»PPHP
¨C¤@ºØ¸ê®Æ®w³£¦³¤@ºØºÞ²zºûÅ@ªºµ{¦¡»y¨¥¡A¥Ø«e¥«±¤Wªº¸ê®Æ®w©Ò¨Ï¥Îªºµ{¦¡»y¨¥°ò¦´X¥G³£¨Ó¦ÛSQL¡GStructured Query Language¡]µ²ºc¤Æ¬d¸ß»y¨¥¡^¡C
SQL»y¨¥³Ìªì¬O¥ÑIBM©ó1970¦~¥Nªì´Á©Ò¶}µoªº¡A¥Î©óÃö³s¦¡¸ê®Æ®w ¡]Relational Databases¡^¤¤ªº¤@ºØ¸ê®Æ®w¬d¸ß»y¨¥¡A§Q¥Î SQL ¥i¥H¥Î¨Ó©w¸q¸ê®Æ®wµ²ºc¡B«Ø¥ß¸ê®Æªí¡B«ü©wÄæ¦ì«¬ºA¡Bªø«×»P·s¼W¸ê®Æ¡Bקï¸ê®Æ¡B§R°£¸ê®Æ¡B¬d¸ß¸ê®Æ¡A¬O¤@ºØ¸ê®Æ®wÀ³¥Îªº¼Ð·Ç»y¨¥¡C
¼Ð·ÇªºSQL»y¨¥³W®æ¬O¥ÑANSI¡]¬ü°ê°ê®a¼Ð·Ç¾Ç·|¡^»PISO¡]°ê»Ú¼Ð·Ç²Õ´¡^³o¨âÓ²Õ´©Ò±À°Ê¨îqªº¡A³Ìªì¬O¦b1986¦~¥ÑANSI¨î©w¨ä¼Ð·Ç¤Æ³W®æ¡AÀH«á¦b1992¦~®É¦A«×±À¥X·sªºª©¥»¡A¤]´N¬O±`Å¥¨ì¤H®a»¡ªº¡uSQL92¡v¡C
¥Ø«e¥«±¤Wªº¸ê®Æ®w©Ò¨Ï¥Îªºµ{¦¡»y¨¥ÁöµM³£¥HSQL¬°¥D¡A¦ý¬O«o¨S¦³¥ô¦ó¤@®a¼t°Óªº¸ê®Æ®w§¹¾ãªº¤ä´©©ÎÀ³¥ÎSQL¡C¨C®a¸ê®Æ®w¼t°Ó¬°¤F°Ó·~©Î²£«~À³¥Îªº¦Ò¶q¡A³£¦³¤Ö³¡¥÷ªº¥\¯à¤£¤ä´©¡A©Î¦Û¦æ¼W¥[¤Ö³¡¤ÀªºSQL©µ¦ù¥\¯à¡A¨Ò¦p¡AMicrosoft SQL Server´N¤£ºâ¬O¨Ï¥Î¼Ð·ÇªºSQL¡A Microsoft ¹ï¼Ð·ÇªºSQL°µ¤F³\¦hªº×§ï»P¥\¯à©µ¦ù¡C
¾¨ºÞ¨C®a¸ê®Æ®w¼t°Óªº¸ê®Æ®wºÞ²zºûÅ@»y¨¥¤£ºÉ¬Û¦P¡A¦ý¬O¡A¥¦ÌÁÙ¬O·½¦Û¼Ð·ÇªºSQL¡A©Ò¥H¦bSQLªº°ò¦¨Ï¥Î¤´¬O¾A¥Î©ó¦U®a¼t°Ó¸ê®Æ®w¡C
¥»³¹¤º®e¬Ò¥HMySQL¸ê®Æ®w¬°¨Ï¥Î¹ï¶H¡A¦b½d¨Ò¥úºÐ\DataBase¥Ø¿ý¤¤¦³¤@ÓMySQL¸ê®Æ®w¡uLEAVE¡v¡A¸ê®ÆÀÉleave.sql¡A½Ð±z±NÀɮ׽ƻs¨ì±zªºµwºÐ¸Ì¨Ã§Q¥ÎphpMyAdmin¸ü¤J¨ìMySQL Server¤¤¡A¥H¤è«K±z¾Þ§@½d¨Ò®É¨Ï¥Î¡C
LEAVE.sql
(364.91 KB)
¤U¸ü¦¸¼Æ: 6
2011-4-21 18:45
µ§ªÌ±NSQLªº±Ôz²Õ¦¨n¯À·§¤À¦p¤U¡G
¸ê®Æ©w¸q»y¨¥¡GData Definition Language¡]DDL¡^¡A¥Î¨Ó«Ø¥ß»P§R°£¸ê®Æ®w¡B¸ê®Æªí¡Kµ¥ªºSQL«ü¥O¡C
¸ê®Æ³B²z»y¨¥¡GData Manipulation Language¡]DML¡^¡A¥Î¨Ó·s¼W¡B§R°£¡Bקï»P¬d¸ß¸ê®Æ®w¤º¸ê®Æ°O¿ýªºSQL«ü¥O¡C
¸ê®ÆºÞ²z»y¨¥¡GData Control Language¡]DML¡^¡A¥Î¨Ó³]©w©ÎÅܧó¸ê®Æ®w¨Ï¥ÎªÌ¡]¨¤¦â¡^ªºÅv¡C
¹w¦sµ{§Ç¡GStored Procedure¡ASQL Server¤¤¹w¥ý³]¥ßªºSQL«ü¥O¡C
¨ä¥L²Õ¦¨n¯À
¼Ó¥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!!
ÀR«ä¦Û¦b :
¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡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¯»µ·