I took once moe a sharp look now that you did a reply with another sample. Actually I was wrong the SQL statement was NOT correct - you forgot the semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --execute.
That's true -- unless you're using that option to execute multiple queries. :-) Then you need semicolons as separators.
For example:
mysql --execute "SELECT NOW();SELECT USER()"
~Michael Iatauro
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]