INSERT
目录
INSERT
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
OUTPUTS è¾åº
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
è¯è
è·
NAME
INSERT - å¨è¡¨ä¸å建æ°è¡
SYNOPSIS
INSERT INTO
table [ ( column [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT }
[, ...] ) | query }
DESCRIPTION æè¿°
INSERT å许æ们å表ä¸æå¥æ°è¡ã æ们å¯ä»¥ä¸æ¬¡æå¥ä¸è¡æå¤è¡ä½ä¸ºæ¥è¯¢ç»æã
ç®æ å表ä¸çå/å段å¯ä»¥æä»»ä½é¡ºåºæåã å¨ç®æ åä¸æ²¡æåºç°çå/å- 段å°æå¥ç¼ºçå¼ï¼ å¯è½æ¯å®ä¹äºç缺çå¼æè NULLã
å¦ææ¯è¡ç表达å¼ä¸æ¯æ£ç¡®çæ°æ®ç±»åï¼ç³»ç»å°è¯å¾è¿è¡èªå¨çç±»å转æ¢ã
è¦æ³å表ä¸æå¥æ°æ®ï¼ä½ å¿é¡»æ INSERT æéï¼ å¦æä½ ä½¿ç¨äº query å- å¥æå¥æ¥èªæ¥è¯¢éçæ°æ®è¡ï¼ ä½ è¿éè¦æ¥æå¨æ¥è¯¢é使ç¨ç表ç SELECT æéã
PARAMETERS åæ°
|
table |
ç°å表çå称ï¼å¯ä»¥æ模å¼ä¿®é¥°ï¼ã
|
column |
表 table ä¸çå段åã
DEFAULT VALUES
ææå段é½ä¼ç¨å®ä»¬ç缺çå¼å¡«åã
expression
èµäº column çä¸ä¸ªææ表达å¼æå¼ã
DEFAULT
è¿ä¸ªå段å°è¢«å段å®çå¡«åã
|
query |
ä¸ä¸ªæ¥è¯¢ï¼SELECT è¯å¥ï¼ï¼å®æä¾æå¥çæ°æ®è¡ã 请åè SELECT è¯- å¥è·åè¯æ³æè¿°ã
OUTPUTS è¾åº
æåå®æåï¼ä¸æ¡ INSERT å½ä»¤è¿åä¸ä¸ªä¸é¢å½¢å¼çå½ä»¤æ ç¾
INSERT oid count
count æ¯æå¥çè¡æ°ã å¦æ count æ£å¥½æ¯ä¸ï¼å¹¶ä¸ç®æ 表æ OIDï¼ é£ä¹ oid æ¯èµäºæå¥è¡ç OIDã å¦å oid æ¯é¶ã
EXAMPLES ä¾å
å表 films éæå¥ä¸è¡ï¼
INSERT INTO
films VALUES
(’UA502’, ’Bananas’, 105,
’1971-07-13’, ’Comedy’, ’82
minutes’);
å¨ç¬¬äºä¸ªä¾åéé¢çç¥äºå段 len å æ¤å¨å®éé¢å°åªåå¨ç¼ºçç NULL å¼ï¼
INSERT INTO
films (code, title, did, date_prod, kind)
VALUES (’T_601’, ’Yojimbo’, 106,
’1961-06-16’, ’Drama’);
å¨ç¬¬ä¸ä¸ªä¾åéï¼æä»¬ç¨ DEFAULT å¼ä½ä¸ºæ°æ®å段ï¼èä¸æ¯å£°æä¸ä¸ªæ°å¼ï¼
INSERT INTO
films VALUES
(’UA502’, ’Bananas’, 105, DEFAULT,
’Comedy’, ’82 minutes’);
INSERT INTO films (code, title, did, date_prod, kind)
VALUES (’T_601’, ’Yojimbo’, 106,
DEFAULT, ’Drama’);
ä»è¡¨ tmp ä¸æå¥å è¡å°è¡¨ films ä¸ï¼
INSERT INTO films SELECT * FROM tmp;
æå¥æ°ç»ï¼
--
å建ä¸ä¸ªç©ºç
3x3
游ææ¿æ¥ç©å-å-å游æ
--
(ææè¿äºæ¥è¯¢å建ç¸åç游æ)
INSERT INTO tictactoe (game, board[1:3][1:3])
VALUES
(1,’{{"","",""},{},{"",""}}’);
INSERT INTO tictactoe (game, board[3][3])
VALUES (2,’{}’);
INSERT INTO tictactoe (game, board)
VALUES (3,’{{,,},{,,},{,,}}’);
COMPATIBILITY å¼å®¹æ§
INSERT å®å¨éµå¾ª SQL æ åãå¯è½ç¢°å°çå³äº query åå¥ç¹æ§çéå¶å¨ SELECT [select(7)] è¯å¥ä¸æç¸å³ææ¡£ã
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh