How to add data to a custom field at the wp_users table?

You cannot add a field to the database table. You can only add a row or column, and neither are supposed to be added directly to the database, especially column!

With add_user_meta you are adding a new row but to the wp_usermeta table, and that should be sufficient for any extra required fields. This table is meant to be used for extending the user’s profile with any amount of custom data, since it is key => value structured.

Again, if you add any column to the wp_users table, you can’t access this data using native WordPress functions. You can only get it by writing a custom SQL query, but I don’t think you actually need this.

Related Posts:

  1. How to automatically apply woocommerce product title to all product images alt tags?
  2. Add custom field to attachments in a specific category
  3. How can update custom meta for all posts
  4. Prevent Data Resubmission On Page refresh
  5. Trying to establish connection to External Database
  6. Passing the custom field values in the wp_get_current_user array function
  7. How to insert a single row to WP database table?
  8. Firing schema via code in functions.php doesn’t work
  9. 3 Slashes appear after Apostrophe in custom fields after updating product-site
  10. Trying to retrieve post meta
  11. Which PHP page is the Default Posts Page
  12. Display Data in Table from External Database in WP using Shortcodes
  13. How to check if a PHP string is different than meta field?
  14. Can’t save php string to a custom field
  15. Why does this update_post_meta function not delete the custom field itself?
  16. How to show/hide php table rows based on the content of custom fields
  17. Custom meta box values are not getting saved for my custom post type
  18. Show ACF field with link to ultimate member profile/WordPress user profile below the post (single post layout)
  19. WP All Import / Update stock quantity from multiple XML files
  20. Changing the order of custom fields in the dashboard for Woocommerce variable products [closed]
  21. Problem with adding custom CSS class to image in ACF Photo Gallery plugin [closed]
  22. Hide a div when a custom field is empty
  23. Conditional On custom field plugin metabox
  24. SQL error with custom query
  25. Delete images from media library when user deletes an image from ACF Gallery
  26. Updating Metadata with Shortcode
  27. Database entry removed on browser refresh, Ajax PHP jQuery
  28. Change wordpress’ database data using ajax – how to get current user id?
  29. Products listing check if meta checkbox is checked
  30. Trying to update Woocommerce meta values
  31. Create a new account on site B with data from the purchase of site A
  32. Is it possible to update the dataset using update_post_meta
  33. Block error message in foreach loop when looping through ACF field
  34. Hide a div if the fiels is empty
  35. How do I get the value of a current user’s custom field?
  36. Store custom field’s multiple values in one user meta key
  37. Get field in readable word
  38. Get meta_query value by user meta array
  39. Weird Behaviour: Not all WordPress Posts appearing
  40. Check if values exists DB
  41. Display custom meta box in my template file
  42. ACF Date fileds to Age Convert [closed]
  43. Appending an ACF custom field to the page title
  44. How to pass value to add_filter wpcf7_form_tag from another function?
  45. Custom Admin Menu Report for Specific User ID
  46. ACF number less than comparison not working
  47. Customize default settings on new sites on multisite
  48. If Custom Field is empty don’t display div
  49. Remove class that has been added by parent theme
  50. Setting up the child theme so as to enable right-to-left WordPress?
  51. Design view breaking on Pages
  52. Hooking new functions to actions + passing parameters
  53. Replace comment avatars and links at the same time
  54. Create Logout Link WordPress Admin Menu
  55. How does WordPress know wich language is chosen when there is a database connection error
  56. Error in custom php function doesn’t exist
  57. Automatic Shortcode Creation with Custom Fields [closed]
  58. Shortcode with PHP issue “Undefined index”
  59. Override a function defined in wp-includes/comment-template.php
  60. Show meta box only for default page template
  61. Is it possible to define variables in a wordpress shortcode, and then call the shortcode using a specific variable?
  62. How do I display offsite database info on my wordpress site?
  63. Countdown to date function?
  64. Hide Heading if ACF Field is empty
  65. calling a custom field value inside functions.php
  66. User Meta Value not echoing despite Var_Dump Showing correct string
  67. WordPress check if current taxonomy has child
  68. get post id from wp_insert_post for get_template_part
  69. Overide Variable in Child Theme
  70. child parent styles enqueue order
  71. Randomize Color Scheme Selection in Theme
  72. Execute Jquery when a specific page in my plugin is loading
  73. AJAX function not working [closed]
  74. Can ‘Custom Field’ data be inserted into this Short Code?
  75. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  76. Display metabox galleries on specific page template in admin editor
  77. display condition based on post term and status
  78. Only the first image uploads
  79. How to update custom fields when post is published?
  80. Inserting a class on before_widget if checkbox is checked
  81. removing the standard dashboard widgets in WP so I Can replace with custom
  82. Gravity Forms: How to add PHP function to confirmation conditional shortcode?
  83. wpdb->query returns different value to phpMyAdmin
  84. What is the correct way to search 3 custom fields only in WordPress?
  85. How to change order inside foreach using wp_enqueue_script?
  86. Change header on one page in WordPress
  87. Adding extra data to shortcode attributes and pass it to JS with wp_localize_script
  88. Allow Comments by Default for Multiple Post Types
  89. Cleaner ‘for each’ loop for registering scripts in functions.php
  90. How to get User Avatar Image with link to Author and User name in Html Title tag?
  91. How to get all users by user_login as a json_encode array?
  92. Allow BBPress participant role to trash topics
  93. Manipulate database of WordPress site with my own scripts
  94. Hide the content before the more tag in the “single page”
  95. Replace TinyMCE with Custom Built Editor
  96. Particular meta tag – viewport – insertion when dealing with plugin
  97. how to loop through blog posts in php
  98. Background Tasks in a WP Cronjob?
  99. How to execute a shortcode within a custom field?
  100. Putting form result in my database