ÃֽŠ°Ô½Ã±Û(DB)
2022.03.01 / 01:29
mysql µ¥ÀÌÅÍ »ðÀÔ, ¼öÁ¤ ½Ã Ư¼ö¹®ÀÚ ³Ö±â(Insert and modify special
MyData
Ãßõ ¼ö 113
°Ô½ÃÆÇ DB¿¡ µ¥ÀÌÅ͸¦ »ðÀÔÇÒ¶§ º»¹®¿¡ ' °¡ ÀÖÀ»¶§ ¹®¹ý ¿À·ù(syntax error)°¡ ¹ß»ýÇÕ´Ï´Ù.
ÀÌ·²¶§´Â °£´ÜÈ÷ ' ¹®ÀÚ ¾Õ¿¡ \ ¸¦ Ãß°¡ÇÏ¿© ÁÝ´Ï´Ù.
Ãß°¡·Î Ư¼ö¹®ÀÚµéÀ» ¾î¶»°Ô »ðÀÔÇÏ´ÂÁö ã¾Æº¸¾Ò½À´Ï´Ù.
Âü°í : https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
Ãâó: https://redthing.tistory.com/entry/mysql-µ¥ÀÌÅÍ-»ðÀÔ-¼öÁ¤-½Ã-Ư¼ö¹®ÀÚ-³Ö±âInsert-and-modify-special-characters-such-as?category=811172 [·¹µå¾ÆÀÌ]