开发者

How can I set a foreign Key in mysql using mysql browser like phpmyadmin?

开发者 https://www.devze.com 2023-04-12 04:05 出处:网络
I am trying to create tables using phpmyadmin but i can\'t define a column as a foreign Key Constraint as we easily do with an sql que开发者_StackOverflow中文版ry. I tried SQLYog Browser as well. Even

I am trying to create tables using phpmyadmin but i can't define a column as a foreign Key Constraint as we easily do with an sql que开发者_StackOverflow中文版ry. I tried SQLYog Browser as well. Even I couldn't find it there.. Is there a way that i can define a foreign key in sql browser like phpmyadmin.


Select the table you need, browse Structure tab. You should be able to see "Relation view" link below the fields.

I would also recommend using Chive - another database management tool - fresh, much more convenient and even more powerful then phpMyAdmin.


Is this something you could still do manually via the query running functionality in phpmyadmin? I know there is a place to run hand typed, manual queries.


You can benefit from Database Designer tool in dbForge Studio for MySQL. Also, you can create foreign keys in visual object editors.

0

精彩评论

暂无评论...
验证码 换一张
取 消