MySQL Monitor

The MySQL Monitor is the command-line SQL interface for the Oracle MySQL 5.5 database. It has far fewer features than the Oracle SQL*Plus environment, because it wasn’t written to support SQL report processing. MySQL Monitor’s purpose is to process SQL statements, which it does well.

There are three differences between the MySQL Monitor and Oracle SQL*Plus environments. One is that the error messages are divided into two types: errors that cause failures and warnings that signal implicit behaviors, such as data type conversions. Another is that the MySQL Monitor processes only SQL and SQL/PSM named blocks. The last difference is that SQL report writing isn’t provided in the MySQL Monitor, and you must purchase or use other tools for report writing.