Question

To execute the contents of a query file ‘exec.sql’ by feeding it to mysql, which command is used?

(a) mysql exec.sql > sampdb

(b) mysql sampdb < exec.sql

(c) mysql exec.sql

(d) mysql exec

This question was addressed to me by my school principal while I was bunking the class.

I'm obligated to ask this question of Interacting with MySQL in portion General MySQL Use of MySQL

Answer 1

Right choice is (b) mysql sampdb < exec.sql

The best I can explain: mysql queries can be run after placing the queries in a file, and then executing it by feeding it to mysql. By default, mysql prints output in a tab-delimited format when it is running in noninteractive mode.