Setting up foreign keys in phpMyAdmin?

If you want to use phpMyAdmin to set up relations, you have to do 2 things. First of all, you have to define an index on the foreign key column in the referring table (so foo_bar.foo_id, in your case). Then, go to relation view (in the referring table) and select the referred column (so in your case foo.id) and the on update and on delete actions.

I think foreign keys are useful if you have multiple tables linked to one another, in particular, your delete scripts will become very short if you set the referencing options correctly.

EDIT: Make sure both of the tables have the InnoDB engine selected.

Related Posts:

  1. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  2. MySQL Error #1133 – Can’t find any matching row in the user table
  3. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  4. How to create a foreign key in phpmyadmin
  5. importing a CSV into phpmyadmin
  6. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  7. What specific database privileges does WordPress need?
  8. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  9. How to copy post titles to post slug in phpmyadmin
  10. How to do a MySQL dump from production site without using a search and replace script for local development?
  11. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  12. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  13. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  14. Can’t find my wordpress DB in phpmyadmin
  15. Backing up and restoring multiple sites efficiently
  16. $wpdb to insert html form information
  17. Setting up WordPress Locally on WAMP for a new site (with one already)
  18. Getting Error Trying to Create Table
  19. Export Yoast Keywords from MySQL/phpMyAdmin
  20. Editing mysql tables/database with wordpress or other app/cms
  21. List users with the most posts in the last 30 days
  22. Export SQL query based on custom field?
  23. Mysql Server keeps crashing
  24. How to bulk delete a certain part of all wordpress posts
  25. When I add metadata, metavalue length is added in to the value in some cases
  26. WordPress fails to install with “Can’t Select Database” Error (WAMPServer)
  27. Find locations of all featured images of draft posts via SQL
  28. SQL query to change custom field in WordPress database
  29. An SQL query to find orphaned image attachments and their meta
  30. cannot log in to the mysql server (wamp and wordpress)
  31. SQL command to export post_content from wp_posts using phpMyAdmin
  32. Need SQL query to find&replace image URL
  33. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  34. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  35. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  36. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  37. When to use SELECT … FOR UPDATE?
  38. Create a new database with MySQL Workbench
  39. Column ‘user_id’ in field list is ambiguous
  40. Database sharding vs partitioning
  41. 1052: Column ‘id’ in field list is ambiguous
  42. Escape string Python for MySQL
  43. 1052: Column ‘id’ in field list is ambiguous
  44. how to overcome ERROR 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO) permanently
  45. SQL ZOO List each continent and the name of the country that comes first alphabetically
  46. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  47. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  48. How to install Python MySQLdb module using pip?
  49. Access denied for user ‘root’@’localhost’ (using password: YES) after new installation on Ubuntu
  50. Dump all tables in CSV format using ‘mysqldump’
  51. How to do a batch insert in MySQL
  52. If variable equals value php [duplicate]
  53. MySQL: Cloning a MySQL database on the same MySql instance
  54. mysqldump data only
  55. PHP date() format when inserting into datetime in MySQL
  56. WordPress mysqli and PDO
  57. Same option_id=0 for 2 options in wp_options?
  58. How to let a user choose an authors and save it to the database?
  59. How to remove ‘GROUP BY’ from SQL query produced from get_posts?
  60. MySQL LIKE not working
  61. Is a MySQL DATETIME or TIMESTAMP value retrieved through $wpdb in UTC?
  62. Emojis getting converted to “?”
  63. Join new table with SQL query
  64. MySQL crashed because of the large number of requests
  65. Why doesn’t this code add a table to my database?
  66. SQL database export-import
  67. Can Someone Help Me Fix This WordPress Missing Argument Error?
  68. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  69. Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
  70. SQL Database, repeated tables?
  71. Visual/Text Editor displays blank pages in WP-Admin- but HTML on client side displays correctly
  72. Code to remove authors with no posts connected to them
  73. SQL Query in WordPress – Getting Impossible WHERE error
  74. Can’t update WordFence Options, clear data manually
  75. WordPress create database not working
  76. database optimization and server errors
  77. Calling mysql_query() on another database, assumes WordPress using that database
  78. WordPress VIP realpath Alternative?
  79. querying user bookmarks from a large number of bookmarks
  80. Pull post name from value of a specific meta key
  81. PHP variables in mysql query
  82. How to fix the amount of comments displayed for each post?
  83. How do I echo all users’ display_name and their meta_value who have a certain meta_key?
  84. How to simulate web traffic to test performance of a website
  85. SQL. Select category descendants
  86. MySQL Actibity without any active visitors via Google Analytics
  87. How to configure WordPress Database for CentOS 7
  88. Why is local wordpress install calling live site executions?
  89. Display MySQL as part of a Page
  90. Migration of wordpress database from mariadb 10.0.20 to 5.5.50
  91. WP Meta Query – mixed AND / OR query doesn’t work
  92. Second completely independent and disposable WordPress installation in subdirectory?
  93. get_results suddenly not working on a single table
  94. Internal error (500) on local & Fatal error on live when trying to access post type edit screen
  95. Query sql for truncate post_content in wp_posts table
  96. Foreach only outputs if id is 0
  97. “Error 1064” when importing msql database after updating wordpress version to 4.2.1
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?

Leave a Comment