re: How can i update the column with some value

Daya, Tuesday, October 22, 2002, 3:26:42 PM, you wrote: DKD> I want to update a field like this DKD> 1) update table abc set col=col+'some const' DKD> 2) update table abc set col=col+col2 DKD> Is is it possible in mysql if yes then how. If col and col2 are string fields, use CONCAT() function:

How can i update the column with some value

Hi, I want to update a field like this 1) update table abc set col=col+'some const' 2) update table abc set col=col+col2 Is is it possible in mysql if yes then how. Thanks and Regards Daya Krishan Dubey - Before posting, ple