What is the purpose of the “term_id” column in the “wp_term_taxonomy” table?

In versions of WordPress prior to 4.2 terms could belong to multiple taxonomies. This is no longer the case and in WordPress 4.2 or newer new terms cannot belong to multiple taxonomies and any existing terms that belong to multiple taxonomies are split into multiple terms whenever they are updated.

You can read this post for an introduction to the change from before it was made: https://make.wordpress.org/core/2015/02/16/taxonomy-term-splitting-in-4-2-a-developer-guide/

There is also this article which describes the splitting process: https://developer.wordpress.org/plugins/taxonomies/split-terms-wp-4-2/

So unless you are dealing with pre-4.2 data the values of these columns should always be the same.

Related Posts:

  1. What does wp_term_taxonomy.parent reference?
  2. Clear Terms from Taxonomy for Specific Post IDs?
  3. How to make a term belong to multiple taxonomies?
  4. Slow wp_term_relationships query
  5. How are terms connected with posts in database?
  6. Is altering a default WordPress database table update safe?
  7. What are terms and taxonomy, how they related to post and how these three are stored in database?
  8. get_tags() return an empty array after added tags with wp_insert_term()
  9. Make an Items attribute searchable (taxonomy using existing attribute)
  10. WordPress database products structure
  11. get value from ‘terms’ table
  12. I cannot change anything in my wordpress database from within wordpress?
  13. get_the_terms is not working
  14. Issue with WordPress Automatically Assigning Terms to Multiple Posts
  15. Where are database files of a WordPress website?
  16. How to create a table [closed]
  17. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  18. WordPress can’t fetch the posts from the database after moving to new server [closed]
  19. Taxonomy term RestApi data 10 rows limitions
  20. why you don’t Implement PDO for access every thing to database
  21. Upload wordpress from localhost to 000webhost
  22. Problem with form database connectivity
  23. Restrict users viewing post using age on database [closed]
  24. How to STOP wordpress trying to update database?
  25. Server database problem
  26. Unable to do WP_User_Query with meta filter
  27. get_terms of specific parent (including the parent itself)
  28. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  29. Best way to search and replace within serialized database strings?
  30. WordPress, Error when trying to insert data >> Notice: wpdb::prepare was called incorrectly
  31. Can I connect WordPress website with an external database?
  32. cannot create product attribute (taxonomy) and add terms on the same execution
  33. Uploaded images not displaying full size preview or inserting into posts
  34. SQL query to rewrite all media URLs to end with .webp
  35. Cant Connect to Database
  36. WP Multisite Users Not Linking
  37. How can i change the nicename and the displayname in a bulk in the database?
  38. Create taxonomy terms from custom field values
  39. What’s the cleanest way to transfer WordPress to a new server
  40. hide_empty property not working when using get_terms
  41. cannot access wp-admin after options table crash and repair
  42. wp_usermeta key problem
  43. How do I find users by password?
  44. How to update multiple row by one query
  45. wp-config was suddenly updated
  46. Display custom data based on URL slug
  47. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  48. Weird WP -Cli Error Connection Refused
  49. How can I get taxonomy term name using term slug & post ID using build in WordPress function or class?
  50. Is it possible to have a form page for logged-out users where values are stored persistently?
  51. WordPress database connection failed, while mysql client is working [closed]
  52. Many images in wp-content/uploads folder that are not in Media Library
  53. How to delete unused terms?
  54. Query a meta key using an array of values where the database value is a string
  55. Order of search results based off of a backend custom field and also in alpha order
  56. How do I check if a post has a term with a particular ancestor/parent?
  57. How to find fresh (last modified) and sql backup?
  58. Database Queries are crashing the server
  59. Uploading to WordPress Database
  60. How to protect my credentials on my clients website
  61. WordPress taxonomy and terms question
  62. Have WordPress Use a Different Database for users
  63. Sharing plugin tables between 2 sites in the same database
  64. Taxonomy Archive URL + Template
  65. Database Errors since site updated to WordPress 6.4.3
  66. $wpdb->update is not working until next page refresh. Is there one more step?
  67. How to generate PDF dynamically based on values from the database in WordPress
  68. Understanding Redundant postmeta Tables in WordPress Database
  69. Put ACF function output code the_terms
  70. update_post_meta returns ID, but nothing in the database
  71. Configure WordPress to use MariaDB over SSL?
  72. Editing a WordPress post content from the database does nothing
  73. How to maintain development losing any user’s data
  74. Merging multiple WP databases into one for a multilanguage site prevents access to language-specific WP administration
  75. How to disable publish_future_post auto add wp_options cron
  76. I have uploaded thousands of files in the uploads folder via FTP and I want to register them into the database without any plugin
  77. Set limitations of wp_update_post()?
  78. Want to use a single database and single table (wp_posts and wp_postmeta) for two different sites
  79. Get a custom post type’s taxonomy type term names displayed as checkboxes and filter
  80. Add tags to blog-posts by php-script
  81. If an Application Password is accidentally revoked, is there any way to restore it?
  82. WordPress post on home page of my website
  83. Help required with local wordpress setup
  84. #1067 – Invalid default value for ‘post_date’ when trying to create a new column
  85. Help with vehicle performance website
  86. Distributed plugin – add support for Cyrillic
  87. wp_update_post function exclude specific field
  88. How is better to store at DB 1-side relationsip from CPT to many Taxonomies Terms ID’s?
  89. Dynamic Gallery: Worpress’ equivalents for Wix’s collection and repeater
  90. WordPress copying data from one custom post type to another
  91. wp-admin login redirecting to home page
  92. How to change all the images in post content to full/orginal size – Thumbnails are broken
  93. large number (bigint) for post ID issue in database
  94. Can I Load posts from an External database if the post is not found on Main WordPress Database
  95. How to list custom taxonomy terms without the hyperlinks?
  96. Add independent connections for reading and writing to the database in WordPress
  97. how to run tests using different db connection
  98. Combining two select posts from mysql – to get least viewed posts
  99. WordPress Admin login problems- PLEASE HELP [closed]
  100. Deleting WordPress posts and media files based on author via MYSQL database
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)