Adding column to wpex_users

You should never modify the WP core tables, all your changes will be undone and the data lost the next time WP updates its table schema.

Instead, if you want to store more data on a user, do what other people do and use user meta:

  • update_user_meta
  • get_user_meta
  • add_user_meta
  • delete_user_meta

You can even query for it with WP_User_Query.

Otherwise, by adding custom columns, you’ll have to write a tonne of SQL code from scratch, and risk major data loss.

Related Posts:

  1. what is the use of /wp-includes/SimplePie?
  2. How to check if image is already stored in a site’s post database? (network)
  3. Inserting choice in database table
  4. How To Make Connection To WordPress Data Base In A Plugin?
  5. Has anyone tried putting PHP ActiveRecord on WordPress?
  6. Changing user_nicename
  7. WordPress will not operate correctly
  8. How to Join two tables from separate databases within WordPress
  9. How can I call a row of user specific data from a custom table added to the WP Database
  10. How to track a users progress through pages by inserting data into WordPress Database?
  11. Import 10,000 Users into WordPress WITH a specific ID for each user
  12. if statement on database query
  13. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  14. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  15. #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  16. How to generate page content from database the right way?
  17. How to create and work with custom data / tables (i.e., for arbitrary data)?
  18. Proper way to edit a post via phpMyAdmin without breaking the compare revisions tool
  19. phpMyAdmin displays error when importing database
  20. Prevent Data Resubmission On Page refresh
  21. SQL QUERY – Select a value directly from the database
  22. How to get the POST TITLE using the POST ID?
  23. Why is the post meta[] empty when I make a call to the wordpress rest api?
  24. WordPress Scheduled Event Request Blocking
  25. Transferring working local PHP site to wordpress – with database (MySQL)
  26. Trying to establish connection to External Database
  27. Getting id of poll from WP database
  28. How to insert a single row to WP database table?
  29. $wpdb->update with multiple parameters gives error
  30. wp search-replace on database returns PHP fatal error: Array and string offset access syntax with curly braces is no longer supported
  31. How does WordPress know wich language is chosen when there is a database connection error
  32. Is it possible to create a wordpress database with php code?
  33. Store a default value for a transient on plugin activation
  34. Split reads to a different connection string
  35. custom user role wordpress – grant guest access to edit.php without insert/update/delete
  36. Dynamic content in template
  37. inserting a post from an extern php file but post content doesn’t show on wp site
  38. Using custom tables for old posts
  39. Databases – Submitting data from inputs to database [closed]
  40. db converts decimal number wrong
  41. Is it best to avoid using $wpdb for security issues?
  42. How can I import an excel column into wordpress database?
  43. Blob file download problem
  44. Execute a function every hour in the background
  45. Create page with custom php script and fetched data
  46. wpdb prepare insert table doesn’t work
  47. Should I use WordPress to skin a database website?
  48. Creating Database Table vs. Adding MetaData to Post & User
  49. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  50. Most commented posts by time period (last 12h, last 24h and etc)
  51. How can I find the cause of a 500 server error?
  52. I can’t update my data through $wpdb
  53. Cant connect to database with php 7.3
  54. How to get image from url from the database?
  55. Set default Database Storage Engine when creating tables with plugins?
  56. Wpdb get->results to out the the month from the db
  57. Creating custom page template from existing PHP site
  58. wordpress site – using custom database and PHP
  59. SQL error with custom query
  60. Unserialize Custom Field & Save as Multiple Rows in WordPress Database
  61. Change wordpress’ database data using ajax – how to get current user id?
  62. add role on WordPress in PHP on a second database
  63. Create a new account on site B with data from the purchase of site A
  64. How to search order using database frontend short code WordPress
  65. Limiting posts based on nested meta_query
  66. Preserving backslashes in post_content
  67. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  68. wp_update_post gives 500 internal error
  69. Unable to insert two value in two different columns (WordPress database)
  70. Retrieving and Displaying Data From a Table
  71. why not selecting multiple rows of same standard_id using SQL query from database?
  72. Using custom php to connect to database blocks wp from accessing galery pictures
  73. Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?
  74. Updating the database after parsing CSV document
  75. getting the values of hidden inputs to use them in a php mysql query
  76. How to display post_content from database in different on template page?
  77. Front end/Database connection in WP
  78. Issue in url update when using wordpress update query
  79. can’t delete a row from post_meta table
  80. special characters not supporting in wordpress
  81. How to set max users to 17.000
  82. How to fetch results from database
  83. How to connect database table to each registered wordpress user.
  84. Let users register weight each day and save it in DB
  85. Query specific posts per user selections from dropdown menus
  86. Create an unique ID number after submit form
  87. Fetching wpdb data from a php file seems to break?
  88. How do I empty a specific meta_value for all users in PHP
  89. Create custom table for wordpress custom registration flow
  90. Custom form that stores data in mysql database
  91. How to get data (not value or name) from radio options to POST to database
  92. Creating a table via dbDelta
  93. wpbd to connect to a VPS mysql database
  94. Retrieve data from external database and insert back in
  95. How to get the last date updated of postmeta?
  96. Putting form result in my database
  97. Bulk data save in custom table
  98. Issue with WordPress Plugin Activation Hook and Table Creation
  99. Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  100. How to improve the performance when using a flat-file dataset and PHP for implementing advanced search function?