MySQL Forums
Forum List  »  Newbie

Batch statements
Posted by: Rich Miller
Date: March 23, 2005 11:24PM

I can't find any other forum that would be a better place for this question, so here goes:

I've created a file with several commands, and I'm executing the commands in the file by "source"ing the file in the mysql client. I'd like to include some statements that are output as the commands are executed. Are there any mysql commands that operate like a "print" or "echo" command?

For example:
....................
print "Now executing first insert..."
INSERT INTO test VALUES (1, "blah blah", 35);

print "Now executing second insert..."
INSERT INTO othertest VALUES (2, "blah blah, 22);
....................

Without any kind of intermediate print statements, I know I'll get the result of the operation ("1 row affected", etc.), but if there are any errors it will be tedious to go through the output and figure out which statement(s) produced the error(s).

Thanks for any assistance you can provide,
Rich

Options: ReplyQuote


Subject
Written By
Posted
Batch statements
March 23, 2005 11:24PM
March 24, 2005 08:32AM
March 24, 2005 08:33AM
March 24, 2005 11:11AM


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.