Jump to content

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


lampstax

Recommended Posts

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.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.