mysql> describe patientinfo;
+---------------+-----------------------+------+-----+---------+----------------
+
| Field | Type | Null | Key | Default | Extra
|
+---------------+-----------------------+------+-----+---------+----------------
+
| pid | mediumint(8) unsigned | NO | PRI | NULL | auto_increment
|
| examnum | varchar(255) | NO | MUL | |
|
| name | varchar(255) | YES | | NULL |
|
| sex | varchar(255) | YES | | NULL |
|
| birthday | varchar(255) | YES | | NULL |
|
| marrystatus | varchar(255) | YES | | NULL |
|
| work | varchar(255) | YES | | NULL |
|
| officephone | varchar(255) | YES | | NULL |
|
| homephone | varchar(255) | YES | | NULL |
|
| telephone | varchar(255) | YES | | NULL |
|
| address | varchar(255) | YES | | NULL |
|
| postnum | varchar(255) | YES | | NULL |
|
| id | varchar(255) | YES | | NULL |
|
| bloodtype | varchar(255) | YES | | NULL |
|
| height | varchar(255) | YES | | NULL |
|
| weight | varchar(255) | YES | | NULL |
|
| yibaostatus | varchar(255) | YES | | NULL |
|
| allergies | mediumtext | YES | | NULL |
|
| chronic | mediumtext | YES | | NULL |
|
| officetype | varchar(255) | YES | | NULL |
|
| rotatedoc | varchar(255) | YES | | NULL |
|
| booktime | int(8) unsigned | YES | | NULL |
|
| localdoc | varchar(255) | YES | | NULL |
|
| zhengduannum | varchar(255) | YES | | NULL |
|
| padesc | varchar(255) | YES | | NULL |
|
| picroute | varchar(255) | YES | | NULL |
|
| examtime | varchar(255) | YES | | NULL |
|
| picdir | mediumtext | YES | | NULL |
|
| CCSJ | mediumtext | YES | | NULL |
|
| CCYJ | mediumtext | YES | | NULL |
|
| helphosp | varchar(255) | YES | | NULL |
|
| exanresult | mediumtext | YES | | NULL |
|
| zhiliaofangan | mediumtext | YES | | NULL |
|
| resultstatus | varchar(10) | YES | | NULL |
|
| fanganstatus | varchar(10) | YES | | NULL |
|
+---------------+-----------------------+------+-----+---------+----------------
mysql> describe accounts;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | varchar(255) | YES | | NULL | |
| examnum | varchar(255) | NO | PRI | | |
| account | varchar(255) | NO | PRI | | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
我用如下的语句创建外键,但是报错了,怎么回事啊
mysql> alter table patientinfo add foreign key(examnum) references accounts(exa
mnum);
ERROR 1005 (HY000): Can't create table '.\test\#sql-cc_25.frm' (errno: 150)
+---------------+-----------------------+------+-----+---------+----------------
+
| Field | Type | Null | Key | Default | Extra
|
+---------------+-----------------------+------+-----+---------+----------------
+
| pid | mediumint(8) unsigned | NO | PRI | NULL | auto_increment
|
| examnum | varchar(255) | NO | MUL | |
|
| name | varchar(255) | YES | | NULL |
|
| sex | varchar(255) | YES | | NULL |
|
| birthday | varchar(255) | YES | | NULL |
|
| marrystatus | varchar(255) | YES | | NULL |
|
| work | varchar(255) | YES | | NULL |
|
| officephone | varchar(255) | YES | | NULL |
|
| homephone | varchar(255) | YES | | NULL |
|
| telephone | varchar(255) | YES | | NULL |
|
| address | varchar(255) | YES | | NULL |
|
| postnum | varchar(255) | YES | | NULL |
|
| id | varchar(255) | YES | | NULL |
|
| bloodtype | varchar(255) | YES | | NULL |
|
| height | varchar(255) | YES | | NULL |
|
| weight | varchar(255) | YES | | NULL |
|
| yibaostatus | varchar(255) | YES | | NULL |
|
| allergies | mediumtext | YES | | NULL |
|
| chronic | mediumtext | YES | | NULL |
|
| officetype | varchar(255) | YES | | NULL |
|
| rotatedoc | varchar(255) | YES | | NULL |
|
| booktime | int(8) unsigned | YES | | NULL |
|
| localdoc | varchar(255) | YES | | NULL |
|
| zhengduannum | varchar(255) | YES | | NULL |
|
| padesc | varchar(255) | YES | | NULL |
|
| picroute | varchar(255) | YES | | NULL |
|
| examtime | varchar(255) | YES | | NULL |
|
| picdir | mediumtext | YES | | NULL |
|
| CCSJ | mediumtext | YES | | NULL |
|
| CCYJ | mediumtext | YES | | NULL |
|
| helphosp | varchar(255) | YES | | NULL |
|
| exanresult | mediumtext | YES | | NULL |
|
| zhiliaofangan | mediumtext | YES | | NULL |
|
| resultstatus | varchar(10) | YES | | NULL |
|
| fanganstatus | varchar(10) | YES | | NULL |
|
+---------------+-----------------------+------+-----+---------+----------------
mysql> describe accounts;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id | varchar(255) | YES | | NULL | |
| examnum | varchar(255) | NO | PRI | | |
| account | varchar(255) | NO | PRI | | |
+---------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
我用如下的语句创建外键,但是报错了,怎么回事啊
mysql> alter table patientinfo add foreign key(examnum) references accounts(exa
mnum);
ERROR 1005 (HY000): Can't create table '.\test\#sql-cc_25.frm' (errno: 150)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货