mysql设计器,MySql设计器中的关系问题

用户在使用PHPMyAdmin进行数据库关系设计时遇到了问题。通常能顺利创建参照完整性的关系,但现在浏览器窗口显示'Loading99%'并弹出一个新的php窗口,而预期的关系没有建立。用户通过ALTER TABLE语句手动添加了外键,问题得到解决。
摘要由CSDN通过智能技术生成

Normally I have no issue with MySQL's PHPmyadmin designer to create referential integrity relations.

All of a sudden, I now get a 99% Loading in my browser window, and a popup php.

Reproduce;

Select a database.

Select designer.

Select 'Set Relation'

Select a primary key

Select a coresponding foriegn key

Approve confirmation

Expected results; (and what I usually get)

A relationship is setup.

A line connecting two keys.

Actual results;

a green label "Loading 99%" appears in upper right corner.

a second window pops up http://localhost/phpmyadmin/pmd_general.php?db=jobhunt&server=1&token=d8235.....

Relationship does not occur.

Is anyone else getting this?

解决方案

While I still do not know why the interface decided to break but an add Forien Key works fine.

ALTER TABLE tableblah

add FOREIGN KEY FCK2-BLAH ([Foreign-Key column]) REFERENCES [primary key table]([primary key column]);

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值