What are the parameters for the MySQL source command?
The source command in MySQL is used to execute SQL script files in the command line, with the following parameters:
- File path: Specify the path of the SQL script file to be executed.
- – v: Show executed SQL statements.
- -t: display the results in text format instead of table format.
- – Display the results in a record format.
- -B: Use batch mode, meaning continue execution even when errors occur.
- -e: Execute the complete SQL statement, even if errors occur.
- -ignore executed SQL statements.
- -c: Do not cache the result to the client, but instead send it directly to standard output.
- Option: -n: Display the SQL statements to be executed without actually executing them.
- Before executing the SQL statement, display the current database and table.
- -p: Prompt the user to enter a password.
The above are commonly used parameters for the source command in MySQL. When using this command, you can choose appropriate parameters based on your needs.