How to create a foreign key in phpmyadmin

You can do it the old fashioned way… with an SQL statement that looks something like this

ALTER TABLE table_name
    ADD CONSTRAINT fk_foreign_key_name
    FOREIGN KEY (foreign_key_name)
    REFERENCES target_table(target_key_name);

This assumes the keys already exist in the relevant table

Related Posts:

  1. importing a CSV into phpmyadmin
  2. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  3. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  4. Error establishing a database connection (Set-up locally)
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  7. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  8. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  9. what does “/index.php?admin/admin_dashboard” in my url mean
  10. How to get size of mysql database?
  11. difference between primary key and unique key
  12. Creating a search form in PHP to search a database?
  13. MySQL Error #1133 – Can’t find any matching row in the user table
  14. How can I prevent SQL injection in PHP?
  15. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  16. MySQL Daemon Failed to Start – centos 6
  17. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  18. MySQL – count total number of rows in php
  19. Data is not constantly loading from custom wordpress table
  20. Check if post of title already exists
  21. $wpdb->delete column values IN ARRAY()?
  22. What specific database privileges does WordPress need?
  23. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  24. Changing user_nicename
  25. Does WordPress cache get_user_meta() results?
  26. WordPress will not operate correctly
  27. How to Join two tables from separate databases within WordPress
  28. error importing localhost export file to server
  29. How to sort results from a custom database table
  30. How to copy post titles to post slug in phpmyadmin
  31. Delete all post meta except featured image
  32. Export only pages and posts with mysql dump
  33. Import 10,000 Users into WordPress WITH a specific ID for each user
  34. How to do a MySQL dump from production site without using a search and replace script for local development?
  35. WP database error for comments_popup_link()
  36. if statement on database query
  37. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  38. No wp-config.php file on local install of wordpress – site still displays
  39. Set Display Name to first and last name (phpmyadmin SQL Query)
  40. Recent comments from my blogs only
  41. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  42. Different database query in function.php using mysqli
  43. Delete all post meta except featured image Using SQL
  44. How to write one comment and publish on every post using database or plugin?
  45. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  46. Adding custom tables to WordPress
  47. phpMyAdmin displays error when importing database
  48. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  49. Can’t find my wordpress DB in phpmyadmin
  50. Create WP_Query to search for posts by their categories or their parent/child categories
  51. WordPress database import: Row size too large
  52. How to display data from custom table in wordpress phpmyadmin
  53. Is it possible to create a wordpress database with php code?
  54. Update results, Before deleting the related category [closed]
  55. How to import a custom MySQL DB table into a WordPress custom post type
  56. Will changing the folder name two directories above a fresh wordpress installation break the site?
  57. database sent to a JSON file
  58. $wpdb to insert html form information
  59. inserting a post from an extern php file but post content doesn’t show on wp site
  60. Not connecting to database in file with multiple MySQL connections
  61. wpdb prepare insert table doesn’t work
  62. Should I use WordPress to skin a database website?
  63. I can’t update my data through $wpdb
  64. Getting Error Trying to Create Table
  65. Export Yoast Keywords from MySQL/phpMyAdmin
  66. Adding data to custom wordpress database table
  67. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  68. List users with the most posts in the last 30 days
  69. Add row to custom database Table and delete all rows older than 1 day
  70. Installing local to live WP into subdirectory
  71. select a single val though a table in wordpress
  72. How to display results from a data table with an encrypted user id?
  73. add_action for publish_post doesn’t work
  74. Mysql Server keeps crashing
  75. Please help! I have a problem with getting wordpress databas
  76. Cant create table on plugin activation
  77. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  78. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  79. How to bulk delete a certain part of all wordpress posts
  80. When I add metadata, metavalue length is added in to the value in some cases
  81. Deleted products from woocommerce are still in the database
  82. Moving a few select DB tables to a new WP instance
  83. Using wpdb to connect to a different database is not working
  84. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  85. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  86. Insert data from form to database
  87. An SQL query to find orphaned image attachments and their meta
  88. can’t delete a row from post_meta table
  89. Missing latest posts and options after DB migration via phpMyAdmin
  90. Check if a database is well installed
  91. How to set max users to 17.000
  92. two wordpress sites, two themes, one database, same content
  93. How to connect database table to each registered wordpress user.
  94. MySQL database migration to WordPress
  95. Custom query_posts() parameter
  96. cannot log in to the mysql server (wamp and wordpress)
  97. SQL command to export post_content from wp_posts using phpMyAdmin
  98. Need SQL query to find&replace image URL
  99. Execute multiple PHP Snippets causes error?
  100. Can’t insert into a database wordpress

Leave a Comment