What setting displays script commands to screen?

[DeepDiverMom]

When I run scripts via &quot;source <filename>&quot;, the results of the script commands display just fine, but I also want the commands themselves to display also, as though I had typed them in at the MySQL prompt. In Oracle, we'd say
&quot;SET ECHO ON&quot; before running the script. What is the MySQL equivalent setting/command?

 

[DeepDiverMom]

Gurus, may I infer from the &quot;0 replies&quot; to this thread that this is a &quot;HARD&quot; question? If a couple of &quot;This Forum's Top Experts!&quot; in the right-hand margin respond with, &quot;I don't know&quot; or &quot;It can't be done&quot;, then I'll understand...Knowing that is better than &quot;0 replies&quot;.

Thanks,

Becca

 

[sleipnir214]

DeepDiverBecca:
No one on that &quot;Top Experts&quot; list has the time, energy, or inclination to answer in the negative to every post he/she can't or won't answer. I, for example, am in that list on at least 6 different fora, so there aren't enough hours in the day to answer in the negative to every post I don't answer.

Or are we supposed to do this just for your posts?

You want to know about the mysql command-line app? Try

http://www.mysql.com/doc/en

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[nigelcohen]

If there is no proper solution, you could always add a &quot;dummy&quot; command before each real command you want, outputing the relevant data.

eg. within the source file, precede each command with something like

select &quot;Command1&quot; from table1 where ref=1;

 

[DeepDiverMom]

Nigel, Thanks for your constructive response. Using your suggestion, I ended up simply with:

SELECT &quot;<command text>&quot;;

...since MySQL doesn't need a FROM clause (as Oracle does).

Your help solved my problem.

Cheers !