Use CONCAT
----- Original Message -----
From: Sanjeev Adhyapak <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 6:42 AM
Subject: Update
> 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
>
>
---------------------------------------------------------------------
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
