Comments on Tech Musings: Using Foreign Keys in MySQL

Thank you really for this!!! I've been looking...

2012-01-06T05:22:13.211-08:00

Thank you really for this!!!
I've been looking for a way to create relationships in phpmyadmin for so long. I've even come across a method where the config files needed to be changed. As much as possible, I want to avoid doing this, because then my database won't be compatible with my classmates' not-yet-configured phpmyadmin (we have a group project, so each of us needed a

Thank you very much Jim - your videos helped me a ...

2012-01-05T04:33:56.044-08:00

Thank you very much Jim - your videos helped me a lot.

thanks a lot man!

2011-12-31T02:45:25.413-08:00

thanks a lot man!

Thanks man, that was so what I was looking for :)

2011-12-15T05:34:36.957-08:00

Thanks man, that was so what I was looking for :)

Thank you so much for this! My database professor...

2011-12-04T17:30:25.888-08:00

Thank you so much for this! My database professor has never used MySQL or phpmyadmin before, but the department told him he had to teach using MySQL, so he is pretty much leaving us to figure out things on our own. These videos were extremely helpful. I'm going to tell other people in my class about them.

This was a tremendous help to me. I too could not ...

2011-11-16T13:12:32.497-08:00

This was a tremendous help to me. I too could not even find the relation view but once you identified the conversion to the innoDB it all came together. You saved me a lot of time as there is not another comprehensive guide online. This should be included on the phpMyAdmin site!

Thanks for making this tutorial, I forgot that you...

2011-11-07T04:13:04.467-08:00

Thanks for making this tutorial, I forgot that you need innoDB to use foreign keys :S

Much thanks to you. Awesome job on the videos even...

2011-11-05T20:14:03.596-07:00

Much thanks to you. Awesome job on the videos even with the low res. I had no problem picking right up on what you were showing me.:-)

Hey thanks a lot for the videos! They were real...

2011-09-13T22:34:13.403-07:00
Hey thanks a lot for the videos!
They were realllly helpfull in my project.

That LEFT OUTER JOIN is horrible for finding missi...

2011-08-09T07:39:16.760-07:00
That LEFT OUTER JOIN is horrible for finding missing records. Use NOT EXISTS instead.

SELECT *
FROM `agenda`
WHERE NOT EXISTS (
SELECT * FROM `meetings` WHERE `meeting_id` = `agenda`.`meeting_id`
)

Then to DELETE:

DELETE
FROM `agenda`
WHERE NOT EXISTS (
SELECT * FROM `meetings` WHERE `meeting_id` = `agenda`.`meeting_id`

Oh Man, that's very cool. Thanks from Mitch

2011-08-03T16:31:38.140-07:00
Oh Man, that's very cool. Thanks from Mitch

Thank you! Excellent tutorial! Now i could do that...

2011-07-29T11:08:10.330-07:00
Thank you! Excellent tutorial! Now i could do that using PHPMyAdmin

Thanks alot!!!!!!!! Really this a great tutorial.....

2011-07-21T03:06:18.798-07:00
Thanks alot!!!!!!!! Really this a great tutorial...once again thanks

Jim. Thank you, Thank you and Thank you. I was sea...

2011-06-24T04:25:28.579-07:00
Jim. Thank you, Thank you and Thank you. I was searching for quite some time before I came across your video. you just saved me so much of frustration.

Great tutorial! it is so helpful

2011-06-24T04:19:55.386-07:00
Great tutorial! it is so helpful

Thank you very much for great tutorial. Finally th...

2011-06-20T08:06:20.676-07:00
Thank you very much for great tutorial. Finally this was my end of searching for InnoDB.

Muchas gracias!!, estabamos trabados con foreing k...

2011-06-16T14:08:00.451-07:00
Muchas gracias!!, estabamos trabados con foreing key. Los videos muy buenos.
Saludos desde Argentina

Great tutorial !!! Thanks for this nice work :)

2011-06-03T05:36:55.665-07:00
Great tutorial !!! Thanks for this nice work :)

You saved my day! Thanks for the videos!

2011-05-20T06:21:47.599-07:00
You saved my day! Thanks for the videos!

somit: thanks buddy :).I always use to do with wri...

2011-05-10T23:34:27.702-07:00
somit: thanks buddy :).I always use to do with writing code, not with phpmyadmin.

thank you for doing this , you said at the start o...

2011-04-30T12:09:32.189-07:00
thank you for doing this , you said at the start of the vid that reason you created this video was for someone like me to save time.

Im used to other database software (oracle) and trying to muddle through php myadmin for a uni project and not being able to figure out fkeys

thanks again

Many thanks for the tutorial, I fumbled through so...

2011-04-25T12:20:51.743-07:00
Many thanks for the tutorial, I fumbled through some other ones, but this one is the best I've seen. It's true a picture does say a thousand words. Thanks agaon

vow,really very useful. it helped me a lot.thanks....

2011-04-17T03:06:48.376-07:00
vow,really very useful. it helped me a lot.thanks....

vow....really very very helpful... thanks a lot......

2011-04-17T03:04:23.493-07:00
vow....really very very helpful... thanks a lot...

Thanks, very usefull, that was just what i need :D...

2011-04-06T15:51:35.025-07:00
Thanks, very usefull, that was just what i need :D