Re: Is this a valid Update Query

2004-09-07 Thread Mark C. Stafford 
On Tue, 7 Sep 2004 15:13:25 -0700, Allen Weeks <[EMAIL PROTECTED]> wrote:
> Is this a valid query 
 
>Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField
> = 'keydata'

Hi Allen,

I notice that you're using both single- and double-quotes. I'm in the
habit of using only single. Does it work for you sans-DQ's?

http://dev.mysql.com/doc/mysql/en/String_syntax.html

If the server SQL mode has ANSI_QUOTES enabled, string literals can be
quoted only with single quotes. A string quoted with double quotes
will be interpreted as an identifier.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is this a valid Update Query

2004-09-07 Thread Allen Weeks 

Hi All,

Is this a valid query and will it achieve the result of appending a carriage
return and some text to the current contents of a "text" type field:

Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField
= 'keydata'

Thanks in advance.

Allen


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]