Execute queries from SQL files

To execute queries from a SQL file, use below query.

MySQL:

There are 2 options:

1. If you are in MySQL command line, execute below query.
   source 'SQLfilePath';
2. If you are in command line/shell, execute below query.
   mysql -u userName -p password database < 'SQLfilePath'

MSSQL:

Use T-SQL, execute below query.

sqlcmd -S databaseName -i "SQLfilePath" -o "outputFilePath"