Menu

MySQL Monitor Modes

MySQL Monitor Modes

MySQL Monitor can be run in two modes. The two modes that can be used are as follows:

  1. Interactive Mode
  2. Batch Mode

Interactive Mode

In the interactive mode, the database user types the SQL queries and commands at the mysql> prompt.

Batch Mode

In batch mode, the MySQL monitor program reads the file and executes the commands. The file can be the database script file with the .sql extension. The database script file can have multiple database commands. 

 Batch mode is useful in automation. When the database user needs to run a large number of database commands. To run the database script file we can use the SOURCE command. For example, to run a script file : test.sql

mysql> SOURCE test.sql

 

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

 

 

Related Posts

MySQL COALESCE() Function

MySQL COALESCE() Function The COALESCE() function in MySQL returns the first non-null value from a list of expressions. If all arguments are NULL, it returns NULL. Syntax COALESCE(expr1, expr2, …, exprN) expr1, expr2, …, exprN: These are the expressions to evaluate. The function returns the first non-null expression from this list. It requires at least […]

MySQL Configurator Tool

MySQL Configurator Tool

MySQL Configurator Tool MySQL Configurator tool allows you to configure and optimize MySQL installations for better performance, security, and functionality. It simplifies the setup process, especially for those who are new to MySQL or need to tailor configurations to specific requirements. Features of MySQL Configurator Some of the features of the tool are as follows: […]