mysql client: how to pause during script execution ?
I give demos by executing scripts, e.g. mysql> source scriptname.sql
I need to pause a script in mid-execution (for discussion) then resume by pressing RETURN or similar.
In Oracle SQL*Plus this is easy: within the script, code:
rem Hit return to continue:
pause
But how to do it *neatly* in the mysql client ? I'm currently spawning out a "read -p" to the Linux OS:
\! read -p 'Hit return to continue:';
(and starting the mysql client with --comments --verbose)
And it works, but the screen output is way too verbose. Anyone know of a neater way ?
Thanks all, Phil
Subject
Written By
Posted
mysql client: how to pause during script execution ?
June 20, 2014 06:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.