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
The topic ‘Changing Usermeta table structure’ is closed to new replies.