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

klein   
   Á¶È¸ 6772   Ãßõ 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 4158/5682
2014-05   4952465   Á¤ÀºÁØ1
2015-12   1489003   ¹é¸Þ°¡
2012-06   6772   ¿µ¿øÇÑÇõ½Å
2005-01   6772   À±È£¿ë
2006-03   6772   ±è°Ç¿ì
2013-06   6772   psj1050
2013-04   6772   song05
2004-11   6772   Á¶¿µ¹Î
2010-06   6772   ¿ÀÁö¶ý
2004-09   6773   ÀåÁø¿ì
2005-02   6773   À̼ºÈ¿
2015-03   6773   ±è¹Î¼ö2
2010-11   6773   ¹ÚÁ¾¿ë
2005-08   6773   ¹Ú±¤´ö
2016-08   6773   ±è°Ç¿ì
2011-10   6773   klein
2004-11   6773   ±¸ÀÚ¹Î
2009-02   6773   À̽¹Î
2005-02   6773   ¿À¼¼Áø
2016-07   6773   µÎ½½¾Æºü
2005-01   6773   ³ëÁÖ¼®
2016-09   6773   audacity