Friday, November 9, 2007

msql man page missing a ;

$ man mysql
gives the following:

Beginning with MySQL 5.0.40, the XML output also uses an XML namespace, as shown here:

shell> mysql --xml -uroot -e "SHOW VARIABLES LIKE ’version%’"



The mysql --xml -uroot -e "SHOW VARIABLES LIKE ’version%’" fails.
Use the following:
mysql --xml -p -uroot -e "SHOW VARIABLES LIKE 'version%';"

No comments: