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. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How to use mysqli_query() in PHP?
  8. How to log in to phpMyAdmin with WAMP, what is the username and password?
  9. How do I restore a dump file from mysqldump?
  10. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  11. How do I quickly rename a MySQL database (change schema name)?
  12. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  13. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  14. Setting up foreign keys in phpMyAdmin?
  15. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  16. Create a new database with MySQL Workbench
  17. what does “/index.php?admin/admin_dashboard” in my url mean
  18. phpMyAdmin: secret passphrase?
  19. How to get size of mysql database?
  20. Forbidden :You don’t have permission to access /phpmyadmin on this server
  21. 1052: Column ‘id’ in field list is ambiguous
  22. 1052: Column ‘id’ in field list is ambiguous
  23. difference between primary key and unique key
  24. Creating a search form in PHP to search a database?
  25. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  26. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  27. MySQL Error #1133 – Can’t find any matching row in the user table
  28. How can I prevent SQL injection in PHP?
  29. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  30. How to check if mysql database exists
  31. Is there a Profiler equivalent for MySql?
  32. How to do a batch insert in MySQL
  33. If variable equals value php [duplicate]
  34. MySQL: Cloning a MySQL database on the same MySql instance
  35. PHP date() format when inserting into datetime in MySQL
  36. MySQL Daemon Failed to Start – centos 6
  37. How get value from URL
  38. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  39. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  40. MySQL – count total number of rows in php
  41. Data is not constantly loading from custom wordpress table
  42. How to return number of found rows from SELECT query
  43. What’s a good strategy for planning WordPress DB growth?
  44. How to properly insert data into custom table via plugin
  45. Check if post of title already exists
  46. $wpdb->delete column values IN ARRAY()?
  47. What specific database privileges does WordPress need?
  48. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  49. How To Make Connection To WordPress Data Base In A Plugin?
  50. Changing user_nicename
  51. Does WordPress cache get_user_meta() results?
  52. WordPress will not operate correctly
  53. How to Join two tables from separate databases within WordPress
  54. error importing localhost export file to server
  55. How to sort results from a custom database table
  56. How can I call a row of user specific data from a custom table added to the WP Database
  57. How to copy post titles to post slug in phpmyadmin
  58. Delete all post meta except featured image
  59. Export only pages and posts with mysql dump
  60. How to merge local and live databases?
  61. How to track a users progress through pages by inserting data into WordPress Database?
  62. Import 10,000 Users into WordPress WITH a specific ID for each user
  63. How to do a MySQL dump from production site without using a search and replace script for local development?
  64. WP database error for comments_popup_link()
  65. if statement on database query
  66. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  67. No wp-config.php file on local install of wordpress – site still displays
  68. Set Display Name to first and last name (phpmyadmin SQL Query)
  69. How Do I Merge Categories With phpMyAdmin
  70. Recent comments from my blogs only
  71. Emojis getting converted to “?”
  72. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  73. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  74. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  75. Different database query in function.php using mysqli
  76. Delete all post meta except featured image Using SQL
  77. How to write one comment and publish on every post using database or plugin?
  78. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  79. How to create and work with custom data / tables (i.e., for arbitrary data)?
  80. Adding custom tables to WordPress
  81. phpMyAdmin displays error when importing database
  82. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  83. Can’t find my wordpress DB in phpmyadmin
  84. Create WP_Query to search for posts by their categories or their parent/child categories
  85. WordPress database import: Row size too large
  86. WordPress not reflecting changed of the database
  87. How to display data from custom table in wordpress phpmyadmin
  88. How can I save unique user data on my site? [closed]
  89. Is it possible to create a wordpress database with php code?
  90. Update results, Before deleting the related category [closed]
  91. How to import a custom MySQL DB table into a WordPress custom post type
  92. Will changing the folder name two directories above a fresh wordpress installation break the site?
  93. Backing up and restoring multiple sites efficiently
  94. database sent to a JSON file
  95. $wpdb to insert html form information
  96. inserting a post from an extern php file but post content doesn’t show on wp site
  97. Using custom tables for old posts
  98. Better ads plugin has 500.000 entries in wp_postmeta
  99. Not connecting to database in file with multiple MySQL connections
  100. Changing root password in PHPMyAdmin for WordPress Database when going live

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)