INSERT è¯å¥
说æ
使ç¨æ¤è¯å¥å¯å°åè¡æå
¥å°è¡¨ä¸ï¼è¯æ³ 1ï¼ï¼æè
å° SELECT è¯å¥çç»ææå
¥å°è¡¨ä¸ï¼è¯æ³ 2ï¼ã
è¯æ³ 1
INSERT [ INTO ] [ owner.]table-name [ ( column-name, ... ) ]
VALUES ( expression, ... )
è¯æ³ 2
INSERT [ INTO ] [ owner.]table-name [ ( column-name, ... ) ]
SELECT statement
ç¨æ³
INSERT è¯å¥ç¨äºå°æ°è¡æ·»å å°æ°æ®åºè¡¨ä¸ã
æå
¥å
å«æå®ç表达å¼å¼çåè¡ãå¦æç»åºå¯éçååå表ï¼åå¼é个æå
¥å°æå®çåä¸ãå¦æ没ææå®ååçå表ï¼åå¼ä»¥å建æ¶ç顺åºï¼ä¸ç¨ SELECT * æ£ç´¢ç顺åºç¸åï¼æå
¥å°è¡¨åä¸ãè¡æå
¥å°è¡¨ä¸çä»»æä½ç½®ã
å¦ææå®åå称ï¼éæ©å表ä¸çåå°æ顺åºä¸åå表ä¸æå®çåå¹é
ï¼æè
æè¿äºåçå建顺åºå¹é
ã
æå
¥å°è¡¨ä¸çå符串å§ç»ä»¥å®ä»¬è¾å
¥æ¶ç大å°åä¿åï¼ä¸è®ºæ°æ®åºæ¯å¦åºå大å°åãå æ¤ï¼æå
¥å°è¡¨ä¸çå符串 Value å¨æ°æ®åºä¸ä¿åæ¶ V å§ç»ä¸ºå¤§åï¼å
¶ä½çåæ¯ä¸ºå°åãSELECT è¯å¥è¿åçå符串为 Valueãä½æ¯ï¼å¦ææ°æ®åºä¸åºå大å°åï¼æææ¯è¾é½ä¼å° Value ä¸ valueãVALUE çè§ä¸ºç¸åãèä¸ï¼å¦æåå主é®å·²ç»å
å« Value æ¡ç®ï¼åä¼æç»æå
¥ valueï¼å 为å®ä¼å¯¼è´ä¸»é®ä¸å¯ä¸ã
UltraLite 表没æææè
ã对å¯éç owner çæ¯ææ¯ä¸ºäºæ¹ä¾¿ä½¿ç¨ç°æç SQL å以ç¼ç¨æ¹å¼çæç SQLãUltraLite æ¥åææè
ï¼ä½å°å
¶å¿½ç¥ã
示ä¾
å° Eastern Sales é¨é¨æ·»å å°æ°æ®åºã
INSERT
INTO department ( dept_id, dept_name )
VALUES ( 230, 'Eastern Sales' )
温馨提示:答案为网友推荐,仅供参考