1.

The datadir variable value can be seen using ______________(a) SHOW VARIABLES(b) DISP VARIABLES(c) CONNECT VARIABLES(d) SHOW VARIABLEThe question was asked in exam.I need to ask this question from Location of the Data Directory topic in chapter MySQL Data Directory of MySQL

Answer»

Right choice is (a) SHOW VARIABLES

Explanation: The data directory location is checked by the ‘datadir’ variable. It can be obtained using a ‘SHOW VARIABLES’ STATEMENT or a ‘mysqladmin’ variables command, LIKE: SHOW VARIABLES LIKE ‘datadir’.



Discussion

No Comment Found

Related InterviewSolutions