MySQL Miscellaneous

MySQL Help command

You can see all options provided by mysql by using --help command.

shell>mysql --help

MySQL Version and Current Date

To know the installed version of MySQL, run the following command on the command prompt.

mysql>SELECT VERSION();
mysql>SELECT CURRENT_DATE();

The above command will output the mysql version and current date as shown below -

MySQL Disconnect Connection

The QUIT commend is used to disconnect from the current connection.

shell>mysql QUIT