At 15:57 -0400 7/27/04, Michael Stassen wrote:
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being
supported on the Windows mysql client. On the other hand, Windows
is so different that I
http://dev.mysql.com/doc/mysql/en/mysql_Commands.html says:
The edit, nopager, pager, and system commands work only in Unix.
wouldn't be surprised if system is not supported. A simple test
would be to start the Windows mysql client and then enter 'help' to
get the list of supported commands and see if 'system' is in the
list. If system is supported, then it will still only work if
Windows recognizes the command you send it, so 'echo' would have to
be valid in Windows.
In any case, system is to be avoided if you want portability, as it
depends on the underlying OS. For portability, I'd stick with the
"SELECT 'text..' AS COMMENT;" syntax, unless someone suggests
something better.
Michael
Richard Mixon (qwest) wrote:
Michael,
Great idea, I can get it to work on SuSE Linux (SLES8 for AMD64) just
fine:
mysql> SYSTEM echo "Some comments" ;
Some comments
But on Windows XP (where my user is running that needs this function):
mysql> SYSTEM echo Some comments ;
--------------
SYSTEM echo Some comments
--------------
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresp
onds to your MySQL server version for the right syntax to use near
'SYSTEM echo
Some comments' at line 1
mysql> SYSTEM "echo Some comments ";
--------------
SYSTEM "echo Some comments "
--------------
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresp
onds to your MySQL server version for the right syntax to use near
'SYSTEM "echo
Some comments "' at line 1
mysql>
Is the SYSTEM command not supported on Windows? I have been unable to
find it documented in the MySQl manual for 4.0.18.
Thanks for your help - Richard
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]