ÃֽŠ°Ô½Ã±Û(DB)
2022.12.26 / 13:19
±¸·çºñ Ä¿¹Â´ÏƼ´Â Tibero6 Database·Î ¿î¿µµÇ°í ÀÖ½À´Ï´Ù.
XMaLL°ü¸®ÀÚ
Ãßõ ¼ö 107
¾È³çÇϼ¼¿ä.. ±¸·çºñ Ä¿¹Â´ÏƼ ¿î¿µÀÚ ±èÁ¤½Ä ÀÔ´Ï´Ù.
±¸·çºñ Ä¿¹Â´ÏƼ´Â MySQL·Î ¿î¿µµÇ°í ÀÖ¾ú´Âµ¥¿ä
À̹ø¿¡ ¼¹öÀÌÀüÀ» ÇÏ¸é¼ Tibero6 Database¸¦ Àû¿ëÇÏ¿´½À´Ï´Ù.
- ÀÛ¾÷ÀϽà : 6¿ù 14ÀÏ(¼ö) 19½Ã ~ 21½Ã
DB º¯°æ °ü·ÃÇؼ ¾Æ·¡ ³»¿ë Á¤µµ ¼öÁ¤ÇÑ°Å °°½À´Ï´Ù.
- µ¥ÀÌÅÍŸÀÔ º¯°æ : int, TEXT µî
- Ä÷³¸í comment, level Ƽº£·Î ¿¹¾à¾î À̽´·Î ¼öÁ¤
- ÇÔ¼ö ¼öÁ¤ : NOW, IFNULL..
- autoincrement -> sequence·Î Àüȯ
- »ç¿ëÀÚ ºñ¹Ð¹øÈ£ ¾ÏÈ£È (MySQL PASSWORD ÇÔ¼ö) JAVA ·Î º¯È¯
- limit -> rownum
- REPLACE, UPDATE ±¸¹® -> MERGE¹®
±×¸®°í ¸¶À̱׷¹À̼ÇÀº MySQL -> Oracle -> Tibero·Î ³Ñ¾î °¥ ¼ö ÀÖ´Ù°í Çϴµ¥..
JAVA ÇÁ·Î±×·¥À¸·Î º°µµ ÀÛ¼ºÇؼ Á÷Á¢ ¼öÇàÇß½À´Ï´Ù.
Âü°íºÎŹµå¸³´Ï´Ù.