Adding user data to an existing user_id

here is Query. Try this, don’t forget to replace user_id with actual userid, meta key with your meta_key like “phone_no” and meta value with your meta_value like “1238899776”.

INSERT INTO `wp_usermeta`(`user_id`, `meta_key`, `meta_value`) 
VALUES (1375,'_lastlogin', '1497621956')`

Related Posts:

  1. how to get list of all users and their metadata
  2. add_user_meta() vs update_user_meta()
  3. How to make a custom column on the Users admin screen sortable?
  4. wp_update_user doesn’t update and update_user_meta does
  5. Get basic Image Uploader on User Profile Page
  6. Return all users with a specific meta key
  7. Capabilities Vs User Meta
  8. Problem storing arrays with update_user_meta
  9. wp_get_current_user always returns 0
  10. get_users is expecting unserialized meta_value
  11. remove user_meta data from database for all users
  12. How to get last login Access Date and time
  13. How to get user metadata for social media url?
  14. Admin user edit – Grab newly submitted user meta immediately after update/submit
  15. how to get specific fields from get_user_meta()
  16. Validating a new user registration field
  17. Check if WP_User_Query ‘include’ is empty
  18. User meta to post
  19. wp_get_current_user in custom file returns 0
  20. Is there a limit to the length/size of serialized data that can be stored as user meta?
  21. Add profile field (usermeta) to Add New User
  22. very last action before during user registration before he is redirected to homepage
  23. Customizing WP tables or adding new ones?
  24. How to Make admin Sidebar Menu always be Collapse by code
  25. Are the default entries for a user in wp_usermeta documented?
  26. get_users / WP_User_Query returns empty when logged out
  27. update_user_meta adding new rows in db for same key
  28. How to query users by meta value, even when meta key doesn’t exist?
  29. What is the meta-box-order_post_hash used for?
  30. Add a member number to new user
  31. Allow role to edit users at lower level with only specific metadata
  32. Hook or action to save profile fields at specific time
  33. User meta conventions / name registry, for social media links
  34. Get user’s ID on logout
  35. How to get the user description with get_users?
  36. get current user not working
  37. Sanitize textarea instead of input
  38. Multiple User-Meta Values in One User-Meta Key
  39. Getting $user_id for the_author_meta outside the loop in multisite
  40. Gravity Custom Merge Tags [closed]
  41. No first_name or user_firstname property in WP_User object
  42. How to insert new element to existing array in usermeta?
  43. Possible bug: update_user_meta is updating two unique meta entries
  44. Update user meta through a front end form
  45. What is the difference between get_the_author_meta() and get_user_meta()?
  46. How to display current_user bio
  47. Is a user_meta research case-sensitive or not
  48. Store user’s registration date as meta
  49. Can I prevent “wp_user_level” from getting added to wp_usermeta on registration?
  50. Get the Google+ and Twitter links – WordPress SEO plugin
  51. How to tell whether a user meta value has increased or decreased [closed]
  52. Showing all users who match 2 meta fields with current user
  53. Adding current user’s ID to the end of PDF hyperlinks in post content
  54. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  55. update_user_meta() not working
  56. How to display user’s avatar on their profile page?
  57. Send mail to user only once when specific check box is selected and updated from profile meta updated by admin
  58. WP_user_query throws a 404 error
  59. Incrementally add or substract from usermeta field
  60. add custom field in user register form
  61. Is it possible to read a result if wp_update_user or update_user_meta fails?
  62. set a user-meta key as avatar
  63. Prevent update of custom user profile meta field on the front end after 1st entry
  64. User last login and user last visit problem
  65. Why get_users() not working on the admin backend?
  66. Can I set user meta for theoretical user 0?
  67. Is there a way to append meta data without creating a race condition?
  68. strange issue with user_meta + json_encode/decode
  69. Inserting and finding multiple values in user-meta fields
  70. WordPress Database Huge wp_usermeta Table
  71. Update user meta on logout
  72. update_user_meta after wordpress in action hooks
  73. I want to update my user meta table
  74. Problem to wp_hash
  75. trying to determine if meta value exists for user and if not auto submit gravity form to redirect
  76. Subscribers Group User meta delete
  77. action user_new_form param is a string
  78. Redirecting users based on custom user meta
  79. Customize Avatar using user meta
  80. get_user_meta returning old data
  81. Why does the usermeta table contain html entities?
  82. get_user_meta returning empty when it’s NOT empty
  83. How can I programmatically show a specific (template) page, like author.php?
  84. WP_User_Query not returning users with meta – what am I missing?
  85. Multiple meta values for one meta key
  86. When is a user’s meta data table loaded?
  87. Display and Update User Custom Meta via user-edit.php
  88. Multiple Email Addresses, One User
  89. WordPress REST API and User meta data
  90. How do I add a dropdown list of numbers 1 – 1000 as an extra profile field?
  91. Get user meta for only the keys with a certain prefix
  92. Serializing User Role for update_user_meta
  93. Randomize Users
  94. Get user_meta values for a user for an array of meta_keys?
  95. Fetch user related data
  96. Displaying field value in new column in users view on wordpress
  97. add_user_meta allows multiple clicks and inserts more than 1 value
  98. Add user meta fields on creating the user
  99. “Select your country” landing page. Remember user choice
  100. How get meta from all users?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)