On Tue, 7 Sep 2004 15:13:25 -0700, Allen Weeks <[EMAIL PROTECTED]> wrote: > Is this a valid query <snip/> > 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]
