DavidSzczesniak
1/16/2018 - 11:07 AM

Running in Batch Mode

There are two ways to put forward commands in mysql, interactive mode and batch mode. In interactive mode, you type in SQL queries or MySQL commands like SHOW DATABSES, through the command line/mysql prompt. In batch mode though, you tell the monitor to read and execute a list of commands from a file. This can be useful if you need to run a large set of commands - hence the name 'batch' mode.

\!h mysql > SOURCE count_users.sql
Database changed
...output...