What is the difference between Batch and Interactive modes of MySQL?

In Interactive mode, we use command line interface and enter queries one by one. MySQL will execute the query and return the result in command line interface.

In Batch mode of MySQL we can write all the queries in a SQL file. Then we can run this SQL file from MySQL command line or from Scheduler Job. MySQL will execute all the queries and return the result.

Leave a Reply

Your email address will not be published. Required fields are marked *