TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

MySQL

MySQL Monitor Modes

Overview

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/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

DataGrip Desktop Shortcut

MySQL /

Launch DataGrip on Windows

DataGrip Download

MySQL /

Install DataGrip IDE on Windows 11

MySQL Workbench Windows 11

MySQL /

New MySQL Connection in Workbench

MySQL Command-line Client

MySQL /

Command-Line MySQL Client

Start MySQL Client

MySQL /

Start MySQL Client on Windows 11

‹ MySQL CREATE DATABASE Statement› Insert Data into a MySQL Database Table

Recent Posts

  • MS Access Data Types
  • Install RAPTOR Avalonia on CentOS
  • Download RAPTOR Avalonia Edition on Windows
  • npm doctor command
  • Build & Run CLion Project
  • Create New CLion C Project on Windows
  • Configure CLion Toolchains on Windows
  • Launch CLion IDE on Windows
  • Activate CLion IDE
  • CLion IDE for C/C++ Development

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com

Go to mobile version