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.
精彩评论