|
||
0
0
°íµµ¸®Àλý
addBatch ?
|
0
0
³Î´©¸®
trigger
|
0
0
LECHUCK
select¸¦ ¿Ö ¹Ýµå½Ã ÇÑ ´ÙÀ½¿¡ ÇؾßÇÏ´ÂÁö¸¦ »ý°¢Çغ¸½Ã¸é µÉ°Å °°½À´Ï´Ù.
¾Æ¸¶µµ µ¥ÀÌÅÍ°¡ ÀÖ´Â °æ¿ì update, ¾øÀ¸¸é insert ¸¦ ÇÏ´Â°É Äõ¸® Çѹø¿¡ Ç϶ó´Â°É ¿øÇÏ´Â°Í °°½À´Ï´Ù. Äõ¸® 2¹ø¿¡ ³ª´²¼ ÇÏ¸é ¶ó¿îµå Æ®¸³ÀÌ ¹ß»ýÇؼ ¼Óµµ°¡ ´À·ÁÁö±â ¶§¹®Àä.. »ç¿ëÇÏ´Â DB¿¡ µû¶ó¼ Àü¿ë Äõ¸®°¡ Àֱ⠶§¹®¿¡ ¸Â´Â°É ã¾Æº¸¸é µÉ°Ì´Ï´Ù. mysql À̶ó¸é insert into foo (id, name) values (\'a\', \'b\') on duplicate key update name=\'b\' ÀÌ·±½ÄÀÔ´Ï´Ù. |
0
0
¾î¼¸µ¶ó
merge ¹® ¸»ÇÏ´Â µí
|
0
0
»ç°ü»ýµµ_¾Ù¸®½º
merge into¸¦ ¸»ÇÏ´Â °Í °°½À´Ï´Ù.
MERGE INTO PPOM A USING (SELECT C1,C2,C3 FROM PPOM) B ON A.C1 = B.C1 WHEN MATCHED THEN UPDATE SET ( C2, C3 ) = ( B.C12, B.C3) WHEN NOTE MATCHED THEN INSERT ( C1, C2, C3) VALUES ( B.C1, B.C2, B.C3 ); |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |
insert into ppom (a,b,c,d)
select a,b,c,d from ppom where a = value