Creating Tables in MySQL 5 with Foreign Keys

Posted by: Admin  :  Category: Phpmyadmin

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

More videos like this at www.theurbanpenguin.com So we have looked at installing MySQL on SLE 11. So now we need a database and tables. We will also add Primary and Foreign Key constraints to the tables. Primary Keys ensure uniqueness of a column values within a table sot hat the row can re identified and Foreign keys ensure integrity by allowing values to be added that exist in another table. For example an employee can only be added to a department that exists.

Linux Cpanel shared hosting: 600 GB disk space, 6 TB bandwidth, free domain, unlimited databases and ftp accounts, web hosting cheap and pro at Hostony

10 Responses to “Creating Tables in MySQL 5 with Foreign Keys”

  1. joshtabory Says:

    Your are the man UP! This was so helpful. Thank you!

  2. theurbanpenguin Says:

    Thank you for your comments, most welcome

  3. gap8u Says:

    Mr Penguin – yer awesome! thank you for all you do….AWESOME!!!!!!!

  4. deadly1010P Says:

    great

  5. khalifamak123 Says:

    this is a piece of diamond!! a rare type of tutor who should be in the Global stage of teaching anyone…Iam African who taught in Sudan, Gulf region and UK now…you are a rare Prof. it is a v honest comment. Pls more and online for everyone..thanks forever…

  6. kdjiofwow Says:

    Is this applicable for mysql 5.1?

  7. jonalice Says:

    Awesome…how easy you navigate and show that…!! God bless..!

  8. theurbanpenguin Says:

    Thank you 🙂

  9. Foaman Says:

    My friend, if you don’t mind my saying so…, you are incredible. 🙂

  10. aicrop02 Says:

    nice thanks ^_^ linux rocks

Leave a Reply

*