Hi Paul,
Using the following fixed things. However, I am surprised at why it is
not working in 4.0.18 (Win32)? Previously I had 4.0.17 (Win32) and
things work perfectly. I guess you are right, it's a bug.
[mysqld]
sql-mode=REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_B
At 17:20 -0600 2/23/04, Paul DuBois wrote:
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing so
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || '
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || ' test string';
+---
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
>
> I am running MySQL in ANSI standard mode. However the following
> statement is giving unexpected result. Am I missing something?
>
>mysql> select 'This is a' || ' test string';
>+---+
>| 'This is a' || ' test st
our query as follows, you should get the result you wanted:
select concat('This is a ', 'test string');
Rhino
- Original Message -
From: "Hassan Shaikh" <[EMAIL PROTECTED]>
To: "MySQL (General List)" <[EMAIL PROTECTED]>
Sent: Monday, Febr
Hi All,
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || ' test string';
+---+
| 'This is a' || ' test string' |
+---+
