¾È³çÇϼ¼¿ä »êÀÌ´Ô ¹«´õ¿î ¿©¸§ Àß º¸³»°í °è½Ã´ÂÁö¿ä.
¿À´ÃÀº 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 ±â¹ÝÀÔ´Ï´Ù.
Ȥ½Ã Äõ¸®¹®¿¡ À߸øµÈ ºÎºÐÀÌ ÀÖ´Ù¸é ¾Ë¼öÀÖÀ»±î¿ä?
°¨»çÇÕ´Ï´Ù.
|