Title: Changing Usermeta table structure
Last modified: September 14, 2021

---

# Changing Usermeta table structure

 *  Resolved [chibeto2004](https://wordpress.org/support/users/chibeto2004/)
 * (@chibeto2004)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/changing-usermeta-table-structure/)
 * I noticed that wordpress usermeta information for a user is saved in different
   record in usermeta table in the database. How can I change the structure of the
   table so that each user can have the information/data saved as a single record.
   for example:
    current usermeta structure is like this: user_Id meta_key meta_value
   1 fname chichi 1 sname Emy 1 age 20 1 gender m 2 fname jude 2 sname Ken 2 age
   32 2 gender m the structure that I desire is: user_id fname sname age gender 
   1 chichi Emy 20 m 2 Jude Ken 32 m

Viewing 1 replies (of 1 total)

 *  Plugin Support [sanjuacharya77](https://wordpress.org/support/users/sanjuacharya77/)
 * (@sanjuacharya77)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/changing-usermeta-table-structure/#post-14888165)
 * Hi [@chibeto2004](https://wordpress.org/support/users/chibeto2004/),
 * Thanks for writing in details and sorry for the delay. Sorry but currently it
   is not possible to change the Usermeta table structure.
 * Regards!

Viewing 1 replies (of 1 total)

The topic ‘Changing Usermeta table structure’ is closed to new replies.

 * ![](https://ps.w.org/user-registration/assets/icon-256x256.gif?rev=3284028)
 * [User Registration & Membership - Free & Paid Memberships, Subscriptions, Content Restriction, User Profile, Custom User Registration & Login Builder](https://wordpress.org/plugins/user-registration/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-registration/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-registration/)
 * [Active Topics](https://wordpress.org/support/plugin/user-registration/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-registration/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-registration/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [sanjuacharya77](https://wordpress.org/support/users/sanjuacharya77/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/changing-usermeta-table-structure/#post-14888165)
 * Status: resolved