Dear Sir,
I want to update one table. situation is like this. i have a table with 3
columns.
tablename - sample
Fields
no - integer
str1 - varchar(100)
str2 - varchar(100)
Now i want to update the table contents like str1 = str1 + str2 for all the
records.
I used the update statement like this
update sample set str1 = str1 + str2;
But is resulted in 0 value in the field str1.
Can anybody suggest the way to do it.
Thank you,
sanjeev.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
