Examveda

Is there any error in executing the following MySQL command?
SELECT USER (),
VERSION (), DATABASE ();

A. Yes, "FROM" is not used

B. No

C. Depends

D. None of the mentioned

Answer: Option B

Solution (By Examveda Team)

This question asks if there's a problem with this MySQL command:
SELECT USER(), VERSION(), DATABASE();

The command is trying to get information about the current user, MySQL version, and the database.
The key point is that in MySQL, the functions `USER()`, `VERSION()`, and `DATABASE()` don't require a `FROM` clause. They retrieve information directly from the system.
So the answer is Option B: No
This command will execute correctly and give you the requested information.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous