At 13:22 -0800 1/17/04, [EMAIL PROTECTED] wrote:
Howdy all,
I've tried to search for an answer to this on the lists (and on google),
but I haven't been able to come up with anything, so I apologize in
advance if this question is redundant.
According to the docs
Howdy all,
I've tried to search for an answer to this on the lists (and on google),
but I haven't been able to come up with anything, so I apologize in
advance if this question is redundant.
According to the docs (http://www.mysql.com/doc/en/SQL_mode.html):
The MySQL server can operate in
By the way, I should point out that I *can* get it to work by adding:
[mysqld]
ansi
Or:
[mysqld]
sql_mode=PIPES_AS_CONCAT
But this is not what I want, since I'm going to be hosting this app
where I won't have access to the server config. I need to be able to set
it on a per
Try this:
mysql set @@session.sql_mode = 'ansi';
Query OK, 0 rows affected (0.00 sec)
mysql select @@session.sql_mode;
++
| @@session.sql_mode
|