[±èÀοµ]´ÔÀÌ ³²±â½Å ±Û:
>¾È³çÇϼ¼¿ä »êÀÌ´Ô ¹«´õ¿î ¿©¸§ Àß º¸³»°í °è½Ã´ÂÁö¿ä.
>
>¿À´ÃÀº mysql Äõ¸®¹®¿¡ ´ëÇØ Áú¹®À» µå¸®°íÀÚ ÇÕ´Ï´Ù.
>
>°¡°èºÎ ÇÁ·Î±×·¥ ¼Ò½º¸¦ ±¸ÇÏ°Ô µÇ¾î¼ ¼¹ö¿¡ ¼³Ä¡Çؼ »ç¿ëÇÏ·Á°í Çϴµ¥
>
>tableÀ» »ý¼ºÇϴ°úÁ¤¿¡¼ ÀÚ²Ù ¿¡·¯°¡ ³ª¼ ÇØ°áÀ» ¸ø º¸°í ÀÖ½À´Ï´Ù.
>
>CREATE TABLE housewife (
>
> no INT(10) NOT NULL auto_increment,
> t_date date DEFAULT '0000-00-00' NOT NULL,
> who INT(3),
> inout INT(3),
> category INT(3),
> settle INT(3),
> receipt INT(3),
> period INT(3),
> content VARCHAR(255),
> amount int(13) DEFAULT '0',
> PRIMARY KEY (NO)
>);
>
>
>À§°¡ ¹®Á¦ÀÇ Äõ¸®¹®Àε¥ À̸¦ ½ÇÇàÇÏ°Ô µÇ¸é
>
>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'inout
INT(3),
>category INT(3),
>settleINT(3),
>receiptINT(3),
>periodINT(3),
>con' at line 6
>
>
>À§¿Í °°Àº ¿¡·¯°¡ ³ªÅ¸³ª¸é¼ Å×À̺íÀÌ ¸¸µé¾îÁöÁö ¾Ê°í ÀÖ½À´Ï´Ù.
>
>¼Ò½º°¡ ¸¸µé¾îÁ³´ø ½Ã±â°¡ ´ë·« 2003³âÀΰÍÀ¸·Î º¸¾Æ mysql4 ¹öÀü´ë
ȯ°æ¿¡¼
>
>Á¦ÀÛÀÌ µÈ°Í °°Àºµ¥¿ä.
>
>Á¦°¡ ¾²°í ÀÖ´Â mysql ȯ°æÀº 5,1.40 UTF8 ±â¹ÝÀÔ´Ï´Ù.
>
>Ȥ½Ã Äõ¸®¹®¿¡ À߸øµÈ ºÎºÐÀÌ ÀÖ´Ù¸é ¾Ë¼öÀÖÀ»±î¿ä?
>
>°¨»çÇÕ´Ï´Ù.
========================================
È®ÀÎÇغ¸´Ï inout ÀÌ ¿¹¾à¾î·Î ¹Ù²î¾ú³×¿ä.
http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html
inout ´ë½Å innout À¸·Î °¡¿îµ¥ n ¸¦ ÇÑ°³ ´õ ºÙ¿©¼ À§ÀÇ sql ¹®¸¸ ½ÇÇàÇغ¸¼¼¿ä.
¸¸¾à ¿¡·¯¾øÀÌ Á¤»óÀûÀ¸·Î table ÀÌ ¸¸µé¾î Áø´Ù¸é, °¡°è ÇÁ·Î±×·¥ ¼Ò½º¸¦ ¸ðµÎ µÚÁ®¼
inout -> innout À¸·Î °íÃÄÁÖ¸é µÉ°Í °°³×¿ä.
|