Comments on: Create foreign key using Phpmyadmin https://www.binarytides.com/create-foreign-key-phpmyadmin/ News, Technology, Entertainment and more Sat, 09 May 2020 14:04:47 +0000 hourly 1 https://wordpress.org/?v=6.8.2 By: junmoni ray https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-157997 Tue, 08 May 2018 08:25:28 +0000 http://www.binarytides.com/blog/?p=192#comment-157997 yes…

]]> By: junmoni ray https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-157996 Tue, 08 May 2018 08:24:36 +0000 http://www.binarytides.com/blog/?p=192#comment-157996 how to create entity relationship diagram using data base tables. plzz help me…

]]> By: Kieu Thi Anh https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-71794 Sun, 27 Mar 2016 10:14:55 +0000 http://www.binarytides.com/blog/?p=192#comment-71794 Hi.
Can you help me some problems.
When I creat relationship between tables, It notice:Missing index on column. Why? And Must I do something to resolve them?
Thanks so much.

]]> By: brodaman https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-69960 Fri, 11 Mar 2016 09:59:01 +0000 http://www.binarytides.com/blog/?p=192#comment-69960 Thanks,helpful, but how can i alter the change from create table sql statement.

]]> By: Badal https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-68039 Thu, 10 Sep 2015 07:07:00 +0000 http://www.binarytides.com/blog/?p=192#comment-68039 In reply to xxx.

Thanks to help me

]]> By: Subhendu Roy https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-67364 Sun, 31 Aug 2014 16:50:00 +0000 http://www.binarytides.com/blog/?p=192#comment-67364 Please someone help me

]]> By: Ashikuzzaman Ashik https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-67227 Sat, 19 Jul 2014 22:52:00 +0000 http://www.binarytides.com/blog/?p=192#comment-67227 Thanks for helping us freely.

]]> By: praveen https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-66180 Fri, 23 May 2014 13:20:00 +0000 http://www.binarytides.com/blog/?p=192#comment-66180 yeah it works fine

]]> By: shanu https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-66034 Thu, 20 Mar 2014 06:28:00 +0000 http://www.binarytides.com/blog/?p=192#comment-66034 thank yewwwww

]]> By: Med https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65749 Mon, 07 Oct 2013 16:17:00 +0000 http://www.binarytides.com/blog/?p=192#comment-65749 Thank you, It was interesting

]]> By: Musa https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65727 Tue, 24 Sep 2013 07:26:00 +0000 http://www.binarytides.com/blog/?p=192#comment-65727 Thanks

]]> By: dev31 https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65181 Thu, 14 Mar 2013 11:13:00 +0000 http://www.binarytides.com/blog/?p=192#comment-65181 worth able info thank u

]]> By: 2m935h https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65180 Fri, 18 Jan 2013 05:14:00 +0000 http://www.binarytides.com/blog/?p=192#comment-65180 Thanks Buddy it really works…

]]> By: pash https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65179 Tue, 15 May 2012 08:37:41 +0000 http://www.binarytides.com/blog/?p=192#comment-65179 Hello…

I have seen your post but in my phpmyadmin the option like relation view and track table does not available only rest of two available i am new user of mysql please help me..

-Prashant

]]> By: vinay https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65178 Wed, 07 Mar 2012 14:17:47 +0000 http://www.binarytides.com/blog/?p=192#comment-65178 Thanks man..! it worked..

]]> By: Binary Tides https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65177 Fri, 02 Dec 2011 13:47:34 +0000 http://www.binarytides.com/blog/?p=192#comment-65177 In reply to slevon.

If you use mysqldump then foreign keys are kept intact in the table definition.
If you restore over existing tables (which dont have foreign key relation) then you need to drop tables so that fresh tables are created again with the correct foreign key relations.

]]> By: slevon https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65176 Fri, 02 Dec 2011 11:21:42 +0000 http://www.binarytides.com/blog/?p=192#comment-65176 Hi,
this is great!
But I experienced that all my relations will be lost when I export and import the db.
Do you know a way to keep this relations alive after a backup/restore process?

Best wishes,
slevon

]]> By: Serikjan https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65175 Sun, 27 Nov 2011 08:25:11 +0000 http://www.binarytides.com/blog/?p=192#comment-65175 Thank you very much. So much help

]]> By: Rakesh Tembhurne https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65174 Fri, 25 Nov 2011 05:54:50 +0000 http://www.binarytides.com/blog/?p=192#comment-65174 That’s what I was looking for. Now I can get associated models work together in CakePHP. Thanks!

]]> By: Dhanya https://www.binarytides.com/create-foreign-key-phpmyadmin/comment-page-1/#comment-65173 Sun, 20 Nov 2011 10:59:57 +0000 http://www.binarytides.com/blog/?p=192#comment-65173 Thank You very much…..
It ws really very useful….

]]>