Write a mysql statement to get user, current date and mysql version
belongs to collection: MySQL Exercises
All Answers
total answers (1)
belongs to collection: MySQL Exercises
total answers (1)
Sql programming
Solution:
VERSION() - This function returns the version of the MySQL database.
CURDATE() - This function returns the current date. It returns the current date as a "YYYY-MM-DD" format if string is used in the function, and as a YYYYMMDD format if numeric context is used in a function.
USER() - This function returns the user name and host name for the current MySQL user.
SYSTEM_USER() - This function returns the current user name and host name for the MySQL connection and equal to USER() method.
To know the installed version of MySQL, user and current date run the following command.
Output of the above code -
+-----------+--------------+----------------+ | VERSION() | CURRENT_DATE | USER() | +-----------+--------------+----------------+ | 5.7.21 | 2018-06-23 | root@localhost |