SQL ¿¡·¯¹ß»ý Mysql Error Num : 1005

klein   
   Á¶È¸ 6922   Ãßõ 0    

Mysql_Query : create table morn_member_table ( uid int(11) unsigned not null auto_increment, member_class tinyint(2) default '0' not null, member_id varchar(20) default '' not null, member_pass varchar(20) default '' not null, member_name varchar(30) default '' not null, member_jumin varchar(13) default '' not null, member_sex tinyint(2) default '0' not null, member_birthday varchar(8), member_tel1 varchar(20), member_tel2 varchar(20), member_tel3 varchar(20), member_email varchar(150), member_zip varchar(10), member_address varchar(255), member_homepage varchar(255), member_automail tinyint(2) default '0' not null, member_recommend varchar(20), member_interest tinyint(2) default '0' not null, member_hobby tinyint(2) default '0' not null, member_religion tinyint(2) default '0' not null, member_blood tinyint(2) default '0' not null, member_job tinyint(2) default '0' not null, member_jobname1 varchar(30), member_jobname2 varchar(30), member_tel4 varchar(20), member_tel5 varchar(20), member_jobzip varchar(10), member_jobaddress varchar(255), member_marriage tinyint(2) default '0' not null, member_marriageday varchar(8), member_introduction text, member_main text, member_admin_memo text, member_point double(11,2) unsigned default '0.00' not null, member_image varchar(255), member_login int(11) unsigned default '0' not null, modify_id varchar(20), modify_ip varchar(20), modify_date int(11) unsigned default '0' not null, register_date int(11) unsigned default '0' not null, approval_date int(11) unsigned default '0' not null, primary key (uid), key member_id (member_id), key member_pass (member_pass), key member_class (member_class), key member_jumin (member_jumin), key member_point (member_point), key register_date (register_date) )
Mysql_Error : Can't create table '.\morn\morn_member_table.frm' (errno: 121)
Mysql_Query : create table morning_member_table ( uid int(11) unsigned not null auto_increment, member_class tinyint(2) default '0' not null, member_id varchar(20) default '' not null, member_pass varchar(20) default '' not null, member_name varchar(30) default '' not null, member_jumin varchar(13) default '' not null, member_sex tinyint(2) default '0' not null, member_birthday varchar(8), member_tel1 varchar(20), member_tel2 varchar(20), member_tel3 varchar(20), member_email varchar(150), member_zip varchar(10), member_address varchar(255), member_homepage varchar(255), member_automail tinyint(2) default '0' not null, member_recommend varchar(20), member_interest tinyint(2) default '0' not null, member_hobby tinyint(2) default '0' not null, member_religion tinyint(2) default '0' not null, member_blood tinyint(2) default '0' not null, member_job tinyint(2) default '0' not null, member_jobname1 varchar(30), member_jobname2 varchar(30), member_tel4 varchar(20), member_tel5 varchar(20), member_jobzip varchar(10), member_jobaddress varchar(255), member_marriage tinyint(2) default '0' not null, member_marriageday varchar(8), member_introduction text, member_main text, member_admin_memo text, member_point double(11,2) unsigned default '0.00' not null, member_image varchar(255), member_login int(11) unsigned default '0' not null, modify_id varchar(20), modify_ip varchar(20), modify_date int(11) unsigned default '0' not null, register_date int(11) unsigned default '0' not null, approval_date int(11) unsigned default '0' not null, primary key (uid), key member_id (member_id), key member_pass (member_pass), key member_class (member_class), key member_jumin (member_jumin), key member_point (member_point), key register_date (register_date) )
Mysql_Error : Can't create table '.\morn\morn_member_table.frm' (errno: 121)
Mysql Error Num : 1005

 

인스톨 자체가 안되내요

머리아파지내요

 

Mysql Error Num : 1005

 

이 에러에 원인이 뭔가요?

ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.
ALpha 2011-10
»Ç·ôÅ° Á¦¾àÁ¶°Ç¿¡ °É·Á¼­¶ó´Âµ¥.. ¾Ë±âÈûµç ²¿ºÎ¶û ¸»ÀÌ¶ó ¸µÅ©·Î ´ë½ÅÇÏ°íÀÚ ÇÕ´Ï´Ù.
http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html
ÀÌÇöÁß 2011-10


QnA
Á¦¸ñPage 4184/5710
2015-12   1693400   ¹é¸Þ°¡
2014-05   5159128   Á¤ÀºÁØ1
2019-04   6922   2CPUÃÖÁÖÈñ
2017-01   6922   ÄĹÚ
2004-10   6923   ±èµ¿¿ì
2016-02   6923   rootidc
2004-09   6923   ¿ø³«¿¬
2011-10   6923   klein
2012-03   6923   ÀÌÀ±ÁÖ
2014-09   6923   ³ªÆÄÀÌ°­½ÂÈÆ
2004-08   6923   ¼ÛÈ­½Ä
2018-07   6923   ¾óÀ½°øÁÖ
2009-01   6923   °­»óÃá
2004-12   6923   ±èÁ¾¹Î
2018-02   6923   ÇÞ»ìÇѽºÇ¬
2020-09   6923   Áø¾È¸¶ÀÌ»ê
2012-08   6923   ±è°Ç¿ì
2005-01   6923   ÀÌÇüµ·
2005-02   6923   ³²°æ¸²
2005-02   6923   ÀåÁø¼ö
2005-07   6923   ÀÌÇØ¿ø
2012-01   6923   ¾Æ¸§´Ù¿î³ëÀ»