PREPARE

中文man手册

目录

NAME PREPARE
SYNOPSIS .sp .nf PREPARE
DESCRIPTION 描述
PARAMETERS 参数
NOTES 注意
COMPATIBILITY 兼容性
译者
跋

PREPARE

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES æ³¨æ
COMPATIBILITY å¼å®¹æ§
è¯è
è·

NAME

PREPARE - åå»ºä¸ä¸ªåå¤å¥½çæ¥è¯¢

SYNOPSIS

PREPARE plan_name [ (datatype [, ...] ) ] AS statement

DESCRIPTION æè¿°

PREPARE åå»ºä¸ä¸ªå·²åå¤å¥½çæ¥è¯¢ã ä¸ä¸ªå·²åå¤å¥½çæ¥è¯¢æ¯æå¡å¨ç«¯çå¯¹è±¡ï¼å¯ä»¥ç¨äºä¼åæ§è½ã å¨æ§è¡ PREPARE è¯å¥çæ¶åï¼æå®çæ¥è¯¢è¢«åæï¼éåä»¥åè§åã å½éåååº EXECUTE è¯å¥çæ¶åï¼ å·²åå¤å¥½çæ¥è¯¢å°±åªéè¦æ§è¡äºãå æ- ¤ï¼åæï¼éåï¼ä»¥åè§åé¶æ®µé½åªæ§è¡ä¸æ¬¡ï¼èä¸æ¯æ¯æ¬¡æ¥è¯¢æ§è¡çæ¶åé½è¦æ§è¡ä¸æ¬¡ã

åå¤å¥½çæ¥è¯¢å¯ä»¥æ¥ååæ°ï¼å¨å®æ§è¡çæ¶åæ¿æ¢å°æ¥è¯¢ä¸çæ°å¼ã è¦ç»ä¸ä¸ªåå¤å¥½çæ¥è¯¢å£°æåæ°ï¼æä»¬éè¦å¨ PREPARE è¯- å¥éåå«ä¸ä¸ªæ°æ®ç±»åçåè¡¨ãå¨æ¥è¯¢æ¬èº«éï¼ä½ å¯ä»¥æç§ä½ç½®æ¥å¼ç¨è¿äºåæ°ï¼ æ¯å¦ $1ï¼$2ï¼çã å¨æ§è¡æ¥è¯¢çæ¶åï¼å¨ EXECUTE è¯- å¥éä¸ºè¿äºåæ°å£°æå®éçæ°å¼ã åè EXECUTE [execute(7)] è·åæ´å¤ä¿¡æ¯ã

åå¤å¥½çæ¥è¯¢æ¯å¨æ¬å°å- å¨çï¼å¨å½ååç«¯éï¼ï¼å¹¶ä¸åªæ¯å¨å½åæ°æ®åºä¼è¯çè¿ç¨ä¸åå¨ã å¦æå®¢æ·ç«¯éåºï¼é£ä¹åå¤å¥½çæ¥è¯¢å°±ä¼è¢«éå¿ï¼å æ- ¤æä»¬å¿é¡»å¨è¢«éæ°ä½¿ç¨ä¹åéæ°åå»ºã è¿ä¹æå³çä¸ä¸ªåå¤å¥½çæ¥è¯¢ä¸è½è¢«å¤ä¸ªåæ¶çæ°æ®åºå®¢æ·ç«¯ä½¿ç¨ï¼ ä½æ¯ï¼æ¯ä¸ªå®¢æ·ç«¯å¯ä»¥åå»ºå®ä»¬èªå·±çå·²åå¤å¥½çæ¥è¯¢æ¥ä½¿ç¨ã

å¦æä¸ä¸ªä¼è¯åå¤ç¨äºæ§è¡å¤§éç±»ä¼¼çæ¥è¯¢ï¼é£ä¹å·²åå¤å¥½çæ¥è¯¢å¯ä»¥è·å¾æå¤§éåº¦çæ§è½ä¼å¿ã å¦ææ¥è¯¢éå¸¸å¤æï¼éè¦å¤æçè§åæèéåï¼é£ä¹æ§è½å·®è·å°éå¸¸ææ¾ã æ¯å¦ï¼å¦ææ¥è¯¢è®¾è®¡è®¸å¤è¡¨çè¿æ¥ï¼æèæå¤ç§è§åè¦æ±åºç¨ãå¦ææ¥è¯¢çè§ååéåç¸å¯¹ç®åï¼ èæ§è¡èµ·æ¥å¼éç¸å½å¤§ï¼é£ä¹å·²åå¤å¥½çæ¥è¯¢çæ§è½ä¼å¿å°±ä¸é£ä¹ææ¾ã

PARAMETERS åæ°

plan_name

ç»äºè¿ä¸ªç¹å®çå·²åå¤å¥½æ¥è¯¢çä»»æååãå®å¿é¡»å¨ä¸ä¸ªä¼è¯ä¸- æ¯å¯ä¸çï¼ å¹¶ä¸ç¨äºæ§è¡æèå é¤ä¸ä¸ªåé¢åå¤å¥½çæ¥è¯¢ã

datatype

å·²åå¤å¥½æ¥è¯¢çæä¸ªåæ°çæ°æ®ç±»åãè¦å¨å·²åå¤å¥½æ¥è¯¢åé¨å¼ç¨è¿ä¸ªåæ°ï¼ä½¿ç¨ $1ï¼$2ï¼çã

statement

ä»»ä½ SELECT, INSERT, UPDATE, æ DELETE è¯å¥ã

NOTES æ³¨æ

å¨ä¸äºæåµä¸ï¼PostgreSQL ä¸ºä¸ä¸ªå·²åå¤å¥½çæ¥è¯¢çæçæ¥è¯¢è§åå¯è½è¿ä¸å¦æç§æ®éæ¹æ³æäº¤å¹¶æ§è¡çæ¥è¯¢çæçè§åå¥½ã è¿æ¯å ä¸ºè¯¥æ¥è¯¢å¨è¢«è§åçæ¶åï¼ä¹æ¯ä¼åå¨è§å¾å¤ææä¼æ¥è¯¢è§åçæ¶åï¼ï¼ å¨æ¥è¯¢ä¸å£°æçä»»ä½åæ°çå®éæ°å¼é½è¿ä¸å¯è§ã PostgreSQL å¨è¡¨ä¸- æ¶éæ°æ®åå¸çç»è®¡ï¼ èä¸å¯ä»¥å©ç¨æ¥è¯¢ä¸çå¸¸éæ¥çæµæ§è¡æ¥è¯¢çå¯è½ç»æã å ä¸ºè¿äºæ°æ®å¨åå¤åªç§å¸¦åæ°çæ¥è¯¢çè§åçæ¶åè¿ä¸å¯å¾ï¼ æä»¥ï¼éåºæ¥å¾è§åå¯è½æ¯æ¬¡å¥½çã è¦æ£æ¥ PostgreSQL ä¸ºå·²åå¤å¥½çæ¥è¯¢éåçæ¥è¯¢è®¡åï¼ ä½¿ç¨ EXPLAIN EXECUTE ã

æå³æ¥è¯¢è§åå PostgreSQL ä¸ºæ¥è¯¢ä¼åçç®çæ¶éçç»è®¡çæ´å¤ä¿¡æ¯ï¼ åé ANALYZE [analyze(7)] ææ¡£ã

COMPATIBILITY å¼å®¹æ§

SQL æ ååå«ä¸ä¸ª PREPARE è¯å¥ï¼ ä½æ¯å®åªç¨äºåµå¥ç SQL å®¢æ·ç«¯ãPostgreSQL å®ç°ç PREPARE è¯å¥çè¯æ³ä¹ç¥æä¸åã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æåé¡µè®¡åæä¾ã
ä¸æ man æåé¡µè®¡åï¼https://github.com/man-pages-zh/manpages-zh

↑