我从网上找了一下MySQL中关于二者的介绍,估计应该在CAA来说也是可用的。
What is difference between Interactive Mode and Batch Mode of mysql client?
Answer No: 90
The mysql client program enables the user to send queries to the MySQL server and receive their results. It can be used interactively or it can read query input from a file in batch mode.
Interactive mode is useful for day-to-day usage, for quick one-time queries, and for testing how queries work.
Batch mode is useful for running queries that have been prewritten and stored in a file. It's especially valuable for issuing a complex series of queries that's difficult to enter manually, or queries that need to be run automatically by a job scheduler without user intervention.