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. Exclude function for custom pages, exclude custom ACF fields
  48. Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  49. Run a filter when a walker runs
  50. How can I use wp_insert_comment to write a comment when a post is edited?
  51. phpMyAdmin displays error when importing database
  52. Using Multiple Submit buttons to trigger customised php functions
  53. Removing unneccessary p-tags (Not every p)
  54. Sum custom field values of particular taxonomy
  55. How to remove the excerpt in the Dzonia Lite theme
  56. comments_number display outside specified span
  57. Choose To Display Post Views With An Options Panel
  58. Set WordPress Default Template
  59. Adding Custom Forms
  60. Shortcode content filter?
  61. SQL QUERY – Select a value directly from the database
  62. Randomise upload filenames (or another solution to hide the original image URL from theft?)
  63. How do I display a user’s previous orders as a select box option on a product?
  64. Using file_get_contents with Gravity Forms uploads folder to create images in the media library returning false
  65. allow subscribers to see private posts without plug in
  66. Replace word in “the_content” only for index.php
  67. How do you add customer capability after Woocommerce purchase?
  68. How to get specific image in media library with php
  69. Function set default image when image not present
  70. How to get the POST TITLE using the POST ID?
  71. Importing hard coded custom field into acf field
  72. Custom location for attached images
  73. Why is the post meta[] empty when I make a call to the wordpress rest api?
  74. WooCommerce – Reset quantity input field when variation changes
  75. Query all posts of a custom taxonomy term
  76. Is it necessary to sanitize wp_set_password user input?
  77. get current product name in functions.php
  78. Get first URL from post content
  79. Setting custom canonical urls
  80. tracking number field in Woocommerce order [closed]
  81. Handling Body class based on Template
  82. Trigger popup in a php if/else statement
  83. Setting a cookie upon specific URL visit
  84. Any possible way to make $wpdb->get_results() return anything else than array?
  85. Get_avatar filter?
  86. Can’t get page content in WordPress
  87. database interactions using OOP
  88. WordPress child theme fails to override parent navigation menu in /inc/structure/header.php
  89. Way to querry data (tags) from a wordpress database?
  90. get post based on category chosen in drop down – The ajax method
  91. Adding Default Settings to Theme My Login plugin
  92. Image as Sales Badge
  93. how to make separate field in wordpress user_data_
  94. Function not working at one place
  95. WordPress Scheduled Event Request Blocking
  96. jQuery not defined
  97. Displaying the Month and Year that a page was Created?
  98. Changing custom logo link
  99. Add a class to the anchor tag on HTML5 gallery
  100. Transferring working local PHP site to wordpress – with database (MySQL)