LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   Does MySQL have an echo? (https://www.linuxquestions.org/questions/linux-software-2/does-mysql-have-an-echo-72908/)

Hangdog42 07-15-2003 09:07 AM

Does MySQL have an echo?
 
Does anyone know if you can echo a line to the screen from within a SQL script?

I've got a SQL script that takes quite a long time to execute and I'd like to have the script print a line to the screen showing what is being executed. What I'm trying to do is the equivalent of a bash echo, so something like echo "Loading table X". I could do this in a bash script, but that would require me to either be at the terminal while the script is running so I could supply my MySQL password or to hard-code my password into the script. Obviously I'm not thrilled about either option. Similarly, I could use the -vvv option to echo the command to the screen, but I'm wondering if there is something a little more elegant.


All times are GMT -5. The time now is 12:20 AM.