Question

In which file are the statements entered in ‘mysql’ saved?

(a) .mysql_queries

(b) .queries

(c) .mysql_history

(d) .history

I had been asked this question in an internship interview.

I want to ask this question from Relocating Data Directory Contents in section MySQL Data Directory of MySQL

Answer 1

Correct answer is (c) .mysql_history

Best explanation: Statements entered in ‘mysql’ are stored in the file named ‘.mysql_history’. This file is located in the home directory itself. The SQL statements can be directly pasted into this file.