INSERT ... ON DUPLICATE KEY UPDATE ... (MySQL 4.1以é) MERGE (Oracle 9i(åé¡ãã)/10g以é) PostgreSQLã§ã¯ãéæ¿å ¥ææ´æ°ãã¾ã ãªãã®ã§ãåãããã«ãããå ´åã¯ãæ¿å ¥åºæ¥ãªãã£ããæ´æ°ãã¾ãã¯ãæ´æ°åºæ¥ãªãã£ããæ¿å ¥ããããã¨ã æ´æ°ãæ¯é çãªããUPDATE or INSERTããããããã BLOBãªã©ããã¼ã¿éãå¤ããã°ãSELECT and (INSERT or UPDATE)ãã§ãããã¨ã â ä¾ã«ä½¿ããã¼ãã«CREATE TABLE users ( id INTEGER PRYMARY KEY, name TEXT ) â PL/pgSQLã®å ´å INSERT_UPDATEã®ä¾ - RDBMSæ¯è¼ 47ãã¼ã¸ç®Â (PDF) UPDATE_INSERTã®ä¾ - ä¾ 37-1. UPDATE/INSERT
{{#tags}}- {{label}}
{{/tags}}