[SOLVED] -x option on mysql prompt, not shell prompt

[lampstax]

Hey guys,

 

When I am on shell prompt, I can query:

 

[root@localhost]# mysql -u root -pxxx -e "SELECT VERSION(), DATABASE()\G" --xml

 

And get this output.

 

<?xml version="1.0"?>

 

<resultset statement="SELECT VERSION(), DATABASE()">

  <row>

        <field name="VERSION()">5.0.22</field>

        <field name="DATABASE()">NULL</field>

  </row>

</resultset>

 

Simple right?

 

However, once I log into the mysql server already and get a mysql> prompt, I cant query "SELECT VERSION, DATABASE(); --xml" and get anything.  It errors.  Maybe its a simple syntax error, can anyone help ?

 

Thanks.

 

[fenway]

You can use command-line parameters in mysql statements.

 

You need to start the CLI that way.

[lampstax]

Oh ok.  So once MySQL is started, it can only use one output mode, not switch back and forth.  You need to declare output mode when you start mysqld.

 

Got it.

 

Thanks.