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

klein   
   Á¶È¸ 6792   Ãßõ 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 4162/5686
2014-05   4983733   Á¤ÀºÁØ1
2015-12   1519753   ¹é¸Þ°¡
2010-03   6794   À¯È£ÁØ
2013-06   6794   psj1050
2005-01   6794   ÃÖ¿µÈ£
2011-03   6794   °¡ºü·Î±¸³ª
2005-02   6795   ÀÌ»ó¹é
2004-12   6795   ½ÅÀç»ó
2016-11   6795   ¸®¿À
2009-02   6795   À̽¹Î
2005-01   6795   À±È£¿ë
2015-03   6795   À嵿°Ç2014
2012-08   6795   À¯È£ÁØ
2014-07   6795   °­¸í¼ö
2013-03   6795   ¼³¿µ¼ö
2005-02   6796   À̼ºÈ¿
2018-08   6796   Win31
2004-09   6796   ¹ÚµÎȯ
2015-03   6796   ±è¹Î¼ö2
2008-04   6796   ±èÁö¿µ
2005-01   6796   À±¿µ¹è
2013-10   6796   ±èȲÁß