ãSQLå
¨ç§°æ¯âç»æåæ¥è¯¢è¯è¨(Structured Query Language)â
ããSQL(STructured Query Language)æ¯ä¸ç§æ°æ®åºæ¥è¯¢åç¨åºè®¾è®¡è¯è¨ï¼ç¨äºååæ°æ®ä»¥åæ¥è¯¢ãæ´æ°å管çå
³ç³»æ°æ®åºç³»ç»ã
ããSQLåæ¶ä¹æ¯æ°æ®åºèæ¬æ件çæ©å±åã
ããSQLæ¯é«çº§çéè¿ç¨åç¼ç¨è¯è¨ï¼å
许ç¨æ·å¨é«å±æ°æ®ç»æä¸å·¥ä½ãä»ä¸è¦æ±ç¨æ·æå®å¯¹æ°æ®çåæ¾æ¹æ³ï¼ä¹ä¸éè¦ç¨æ·äºè§£å
·ä½çæ°æ®åæ¾æ¹å¼ï¼æ以å
·æå®å
¨ä¸ååºå±ç»æçä¸åæ°æ®åºç³»ç»å¯ä»¥ä½¿ç¨ç¸åçSQLè¯è¨ä½ä¸ºæ°æ®è¾å
¥ä¸ç®¡ççæ¥å£ãå®ä»¥è®°å½éåä½ä¸ºæä½å¯¹è±¡ï¼ææSQLè¯å¥æ¥åéåä½ä¸ºè¾å
¥ï¼è¿åéåä½ä¸ºè¾åºï¼è¿ç§éåç¹æ§å
许ä¸æ¡SQLè¯å¥çè¾åºä½ä¸ºå¦ä¸æ¡SQLè¯å¥çè¾å
¥ï¼æ以SQLè¯å¥å¯ä»¥åµå¥ï¼è¿ä½¿ä»å
·ææ大ççµæ´»æ§å强大çåè½ï¼å¨å¤æ°æ
åµä¸ï¼å¨å
¶ä»è¯è¨ä¸éè¦ä¸å¤§æ®µç¨åºå®ç°çåè½åªéè¦ä¸ä¸ªSQLè¯å¥å°±å¯ä»¥è¾¾å°ç®çï¼è¿ä¹æå³çç¨SQLè¯è¨å¯ä»¥ååºé常å¤æçè¯å¥ã
ããç»æåæ¥è¯¢è¯è¨(Structured Query Language)ææ©æ¯IBMçå£çº¦çç 究å®éªå®¤ä¸ºå
¶å
³ç³»æ°æ®åºç®¡çç³»ç»SYSTEM Rå¼åçä¸ç§æ¥è¯¢è¯è¨ï¼å®çå身æ¯SQUAREè¯è¨ãSQLè¯è¨ç»æç®æ´ï¼åè½å¼ºå¤§ï¼ç®åæå¦ï¼æ以èªä»IBMå
¬å¸1981å¹´æ¨åºä»¥æ¥ï¼SQLè¯è¨å¾å°äºå¹¿æ³çåºç¨ãå¦ä»æ 论æ¯åOracleãSybaseãInformixãSQL Serverè¿äºå¤§åçæ°æ®åºç®¡çç³»ç»ï¼è¿æ¯åVisual FoxporoãPowerBuilderè¿äºPCä¸å¸¸ç¨çæ°æ®åºå¼åç³»ç»ï¼é½æ¯æSQLè¯è¨ä½ä¸ºæ¥è¯¢è¯è¨ã
ããç¾å½å½å®¶æ åå±(ANSI)ä¸å½é
æ ååç»ç»ï¼ISOï¼å·²ç»å¶å®äºSQLæ åãANSIæ¯ä¸ä¸ªç¾å½å·¥ä¸ååä¸éå¢ç»ç»ï¼è´è´£å¼åç¾å½çåå¡åé讯æ åãANSIåæ¶ä¹æ¯ISOåInternational Electrotechnical Commission(IEC)çæåä¹ä¸ãANSI åå¸ä¸å½é
æ åç»ç»ç¸åºçç¾å½æ åã1992å¹´ï¼ISOåIECåå¸äºSQLå½é
æ åï¼ç§°ä¸ºSQL-92ãANSIéä¹åå¸çç¸åºæ åæ¯ANSI SQL-92ãANSI SQL-92ææ¶è¢«ç§°ä¸ºANSI SQLã尽管ä¸åçå
³ç³»æ°æ®åºä½¿ç¨çSQLçæ¬æä¸äºå·®å¼ï¼ä½å¤§å¤æ°é½éµå¾ª ANSI SQL æ åãSQL Server使ç¨ANSI SQL-92çæ©å±éï¼ç§°ä¸ºT-SQLï¼å
¶éµå¾ªANSIå¶å®ç SQL-92æ åã
ããSQLè¯è¨å
å«4个é¨åï¼
ããâ» æ°æ®å®ä¹è¯è¨(DDL)ï¼ä¾å¦ï¼CREATEãDROPãALTERçè¯å¥ã
ããâ» æ°æ®æä½è¯è¨(DML)ï¼ä¾å¦ï¼INSERTãUPDATEãDELETEè¯å¥ã
ããâ» æ°æ®æ¥è¯¢è¯è¨ï¼ä¾å¦ï¼SELECTè¯å¥ã
ããâ» æ°æ®æ§å¶è¯è¨ï¼ä¾å¦ï¼GRANTãREVOKEãCOMMITãROLLBACKçè¯å¥ã
ããSQLè¯è¨å
æ¬ä¸¤ç§ä¸»è¦ç¨åºè®¾è®¡è¯è¨ç±»å«çéè¿°å¼ï¼æ°æ®å®ä¹è¯è¨(DDL)ä¸æ°æ®æä½è¯è¨(DML)ã
ããä¸é¢æ们å°ä»ç»è¿ä¸¤ç±»è¯è¨:
温馨提示:答案为网友推荐,仅供参考