Sam --
Please use REPLY-ALL when sending email to the list.
Can you use \t? I don't think so.
I know that if you want to enter in '\t', you will need to escape it '\\t',
but MySQL may treat that as something else. It may treat it as a TAB in its
own right, as I know that it will replace '\\r' with a Carriage Return in
BLOB and TEXT fields.
You should use something like pipe '|', brace '[', or bracket '{' and then
use code to do a replace().
You should try it though, as I have not. It may work just fine, but your
application code is really the way you want to do this.
J.R.
1-Can I use Tab (\t) instead?
2- Can I insert the date this new data was added to the field?
J.R. Bullington [EMAIL PROTECTED] wrote:
CONCAT_WS() works as well, but the format is still the same. You still want
to add your new data to your old data.
UPDATE tmpTable SET Textarea = CONCAT_WS(',',Textarea,'data you wish to
add') WHERE ID = someID
Just remember to make the delimiter something that you wouldn't normally see
in a textfield so that you can differentiate between the new text and the
old text.
J.R.
From: sam rumaizan
Sent: Friday, April 06, 2007 12:31 PM
To: [EMAIL PROTECTED]
Subject: re: append information
How About CONCAT_WS()
J.R. Bullington wrote:
Use the CONCAT() function to achieve this:
UPDATE tmpTable SET Textarea = concat(Textarea,'data you wish to add') WHERE
ID = someID
HTH!
From: sam rumaizan
Sent: Thursday, April 05, 2007 12:23 PM
To: mysql@lists.mysql.com
Subject: append information
I have a question if you don't mind.
The update statement will replace the existing information. What if I
have Textarea instead and I want to add information to the field
without erasing previous information. Basically append information
-
Looking for earth-friendly autos?
Browse Top Cars by Green Rating at Yahoo! Autos' Green Center.
Sucker-punch spam with award-winning protection.
Try the free Yahoo! Mail Beta.
_
Looking for earth-friendly autos?
Browse
http://autos.yahoo.com/green_center/;_ylc=X3oDMTE4MGw4Z2hlBF9TAzk3MTA3MDc2B
HNlYwNtYWlsdGFncwRzbGsDZ3JlZW5jZW50ZXI- Top Cars by Green Rating at
Yahoo! Autos' Green Center.
