Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
2 Contributions
Ranked #72.7K
Discussions / Questions x 1
~269 People Reached
Favorite Forums
Databases x 2
Favorite Tags
mysql x 2
query x 2
sql x 2
Member Avatar for theshakti
Bifurcate Data from one column into many column
Share on Facebook Share on Twitter Share on LinkedIn

Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 …

Databases mysql query sql
Member Avatar for theshakti
0
2
269