Hello.
On Mon, Apr 08, 2002 at 11:24:56AM -0400, [EMAIL PROTECTED] wrote:
[...]
> still...I wonder why I got a 'Query OK, 1 row affected' message
[...]
> > insert into table (key, field) values (1, 'test'||CHAR(59)||' string');
> >
> > it seems to work initially...(Query OK, 1 row affected (
Hi.
Have a look at http://www.mysql.com/doc/E/x/Extensions_to_ANSI.html
(rather at the end). || has a different meaning in MySQL started
without explicit --ansi. Also see
http://www.mysql.com/doc/A/N/ANSI_mode.html.
Bye,
Benjamin.
On Mon, Apr 08, 2002 at 11:08:15AM -0400, [EMAIL PROTEC
nevermind...instead of using '||' to concat the fields i needed to use the CONCAT()
function. So the syntax should have been:
insert into table (key, field) values (1, CONCAT('test',CHAR(59), ' string'));
still...I wonder why I got a 'Query OK, 1 row affected' message
-Don
>
