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

klein   
   Á¶È¸ 6793   Ãßõ 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 3753/5686
2015-12   1520075   ¹é¸Þ°¡
2014-05   4984106   Á¤ÀºÁØ1
2011-10   5909   ½Å°ü¾Ç»ê
2011-10   7397   ¹ü¹üÀÌ
2011-10   5402   ¹ü¹üÀÌ
2011-10   5924   ½ÂÈĴϵµÄì
2011-10   5528   ½ÂÈĴϵµÄì
2011-10   5064   Áö¸§ÆÒ´õ
2011-10   5649   ÇÏ¿ìµðÀÚÀÎ
2011-10   6794   klein
2011-10   6139   ¹æoÈ¿o¹®
2011-10   6050   ¼­¿ïI±èµ¿¼ö
2011-10   5159   ¶Ñ¶Ñ±è´ë¿ø
2011-10   5594   ±è°Ç¿ì
2011-10   5783   ¹æoÈ¿o¹®
2011-10   8544   ¹Ú
2011-10   4928   ¹ü¹üÀÌ
2011-10   4754   ·Î±×¾Æ¿ô
2011-10   5382   ÃÖµ¿Çö
2011-10   5916   ±è°Ç¿ì
2011-10   6577   Á¤ÀÇÇÑ
2011-10   5697   ȲÀçÇÊ