mysql — The MySQL Command-Line Client • --xml ,  -X Produce XML output. <field name=" column_name ">NULL</field> The output when  --xml  is used with  mysql  matches that of  mysqldump --xml . See Section 4.5.4, “mysqldump — A Database Backup Program” , for details. The XML output also uses an XML namespace, as shown here: shell>  mysql --xml -uroot -e "SHOW VARIABLES LIKE ’version%’" <?xml version="1.0"?> <resultset <row> <field name="Variable_name">version</field> <field name="Value">5.0.40-debug</field> </row> <row> <field name="Variable_name">version_comment</field> <field name="Value">Source distribution</field> </row> <row> <field name="Variable_name">version_compile_machine</field> <field name="Value">i686</field> </row> <row> <field name="Variable_name">version_compile_os</field> <field name="Value">suse-linux-gnu</field> </row> </resultset> • --zstd-compression-level= level The compression level to use for connections to the server that use the  zstd  compression algorithm. The permitted levels are from 1 to 22, with larger values indicating increasing levels of compression. The default  zstd  compression level is 3. The compression level setting has no effect on connections that do not use  zstd  compression. For more information, see Section 4.2.8, “Connection Compression Control” . This option was added in MySQL 8.0.18. mysql  sends each SQL statement that you issue to the server to be executed. There is also a set of commands that  mysql  itself interprets. For a list of these commands, type  help  or  \h  at the  mysql> prompt: 4.5.1.2 mysql Client Commands mysql>  help List of all MySQL commands: Note that all text commands must be first on line and end with ’;’ ? (\?) Synonym for ‘help’. clear (\c) Clear the current input statement. connect (\r) Reconnect to the server. Optional arguments are db and host. delimiter (\d) Set statement delimiter. edit (\e) Edit command with $EDITOR. ego (\G) Send command to mysql server, display result vertically. 433