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

klein   
   Á¶È¸ 6883   Ãßõ 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 1521/5699
2014-05   5102299   Á¤ÀºÁØ1
2015-12   1638839   ¹é¸Þ°¡
2011-10   6884   klein
2014-01   6884   µþ±â´ëÀå
2015-11   6884   ȸ¿øK
2012-06   6884   °øÆÈÀÌ
2019-07   6884   ¿¡½ºÁ¦ÀÌ¿¡½º
2005-01   6884   ±èÁöȯ
2004-12   6884   ±è±â¹ü
2018-03   6884   ³Ê¸¸¹Ï´Â´Ù
2009-12   6884   À̽¹Î
2020-01   6884   motu
2005-01   6883   ±è´ëÆò
2013-04   6883   µÎÆ÷¸®
2014-08   6883   ½çÇÃ
2012-12   6883   µþ±â´ëÀå
2006-01   6883   ȲÀϱ¸
2005-02   6882   ±è°Ç¿ì
2011-04   6882   °¡ºü·Î±¸³ª
2004-09   6882   °í´ëÁØ
2009-02   6882   À̽¹Î
2017-02   6882   Miru