Hello- I've just started using MySQL so this is absolutely a 'newbie' question. I'm used to working with Oracle's SQL*Plus which is a very different tool. In SQL*Plus, I could type 'l' or 'list' at the SQL*Plus prompt and see a printout to STDOUT (the screen) of the current command in the buffer. Apparently, mysql duplicates this functionality via the 'print' and/or '\p' function. However, even if I have an SQL statement in memory, when I type in this command at the mysql prompt, it simply prints the following:
mysql> print -------------- -------------- This seems to indicate that nothing is in the buffer, however if I type 'edit' the command appears from the buffer. Am I doing something wrong? I'm using MySQL v. 3.23.41 on Linux 7.1. I have another related question. Are we always forced to execute an SQL command immediately after using an editor? In other words, when I type 'edit', edit my command and then exit the editor, I'm released to the '->' prompt which forces me to either clear the buffer or execute the query, neither of which I would like to do immediately. Any advice or help with these issues would be appreciated. Thanks! Rob P.S. Another useful command which doesn't seem to be a part of the feature set for the mysql command line utility is a pause option. In Oracle SQL*Plus, I could set a pause feature on by entering the command 'set pause on', and I would be allowed to view a few returned records at a time. Is that option available in the mysql command line tool? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
