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 different SQL modes, and can apply
these modes differentially for different clients
"You can set...the SQL_MODE variable with SET [SESSION|GLOBAL]
SQL_MODE='modes' Setting the SESSION variable affects only the
current client You can retrieve the current mode by issuing a
SELECT @@sql_mode statement."
Okay, fair enough. My app needs ANSI (or at least PIPES_AS_CONCAT). So
here I go...
mysql> \s
--
mysql Ver 12.22 Distrib 4.0.17, for pc-linux (i686)
Connection id: 8
Current database: mysql
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Server version: 4.0.17-standard
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 day 14 hours 32 min 19 sec
Threads: 1 Questions: 708 Slow queries: 0 Opens: 419 Flush tables: 1
Open tables: 48 Queries per second avg: 0.005
--
mysql> SET SESSION SQL_MODE='ANSI';
ERROR 1193: Unknown system variable 'SQL_MODE'
mysql> SET SESSION sql_mode='ANSI';
ERROR 1193: Unknown system variable 'sql_mode'
mysql> SELECT @@sql_mode;
ERROR 1193: Unknown system variable 'sql_mode'
mysql> show variables like '%mode%';
+---+---+
| Variable_name | Value |
+---+---+
| sql_mode | 0 |
+---+---+
1 row in set (0.00 sec)
Huh? Was the documenation just plain lying to me? What gives? Any help
would be extremely appreciated.
--Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]