MySQL Forums
Forum List  »  Newbie

mysql client: how to pause during script execution ?
Posted by: Phil Jenkinson
Date: June 20, 2014 06:09AM

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

Options: ReplyQuote


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.