ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[±Ð¾Ç] ²Ä9³¹ SQL«ü¥O»PPHP

[±Ð¾Ç] ²Ä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)
µ§ªÌ±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¯À
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD