Hi,
I am using MySQL with Witango and I want to append some text to a field in
an UPDATE SQL. MySQL doc indicates you can do this.
UPDATE t1 SET col1 = col1 + 1;
I have tried the following:
UPDATE emaillist SET E_Deleted = { d '2010-06-17' }, E_Source =
E_Source'CRON' WHERE
you need to use the CONCAT sub function
E_Source = CONCAT(E_Source,'CRON')
On Jun 17, 2010, at 3:02 PM, Fogelson, Steve wrote:
Hi,
I am using MySQL with Witango and I want to append some text to a
field in an UPDATE SQL. MySQL doc indicates you can do this.
UPDATE t1 SET col1 = col1 +
Thanks Ben
_
From: Ben Johansen [mailto:b...@pcforge.com]
Sent: Thursday, June 17, 2010 4:59 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: MySQL Update (OT)
you need to use the CONCAT sub function
E_Source = CONCAT(E_Source,'CRON')
On Jun 17, 2010, at 3:02