lampstax Posted July 10, 2008 Share Posted July 10, 2008 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. Link to comment https://forums.phpfreaks.com/topic/114045-solved-x-option-on-mysql-prompt-not-shell-prompt/ Share on other sites More sharing options...
fenway Posted July 10, 2008 Share Posted July 10, 2008 You can use command-line parameters in mysql statements. You need to start the CLI that way. Link to comment https://forums.phpfreaks.com/topic/114045-solved-x-option-on-mysql-prompt-not-shell-prompt/#findComment-586920 Share on other sites More sharing options...
lampstax Posted July 11, 2008 Author Share Posted July 11, 2008 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. Link to comment https://forums.phpfreaks.com/topic/114045-solved-x-option-on-mysql-prompt-not-shell-prompt/#findComment-588000 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.