Click here to Skip to main content
15,215,864 members
Rate this:
Please Sign up or sign in to vote.
See more:
Any one help me.

i want to inert two column values as one column using mysql. i want the format of (sandy -5,xxx).
Posted
Comments
JakirBB 18-Jul-12 7:06am
   
Clarify your problem by giving example..
Nobody likes to answer such question.
Rate this:
Please Sign up or sign in to vote.

Solution 2

So you use string concatenation to combine the two columns. It would help to know your DB format, and if you mean two values from two columns in the same table or another one, but, that's the answer, you select the two and combine them to make one new string.
   
Rate this:
Please Sign up or sign in to vote.

Solution 1

I guess that you need to concatenate the strings and all you need to do is use a string concatenation function
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100