Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - "mysql" - Command Line End User Interface

By: FYIcenter.com

(Continued from previous topic...)

What Is the Command Line End User Interface - mysql?

"mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features:

  • "mysql" is command line interface. It is not a Graphical User Interface (GUI).
  • "mysql" supports all standard SQL Data Definition Language (DDL) commands for the server to execute.
  • "mysql" supports all standard SQL Data Manipulation Language (DML) commands for the server to execute.
  • "mysql" supports many of non-SQL commands that "mysql" will execute by itself.
  • "mysql" provides access to the server-side help system.
  • "mysql" allows command files to be executed in a batch mode.
  • "mysql" allows query output to be formated as HTML tables.
  • "mysql" allows query output to be formated as XML elements.

(Continued on next topic...)

  1. What Is the Command Line End User Interface - mysql?
  2. What Are the "mysql" Command Line Options?
  3. What Are the "mysql" Command Line Arguments?
  4. How Many SQL DDL Commands Are Supported by "mysql"?
  5. How Many SQL DML Commands Are Supported by "mysql"?
  6. What Are the Non-Standard SQL Commands Supported by "mysql"?
  7. How To Get Help Information from the Server?
  8. How To Run "mysql" Commands from a Batch File?
  9. How To Return Query Output in HTML Format?
  10. How To Return Query Output in XML Format?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...