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:

  1. File path: Specify the path of the SQL script file to be executed.
  2. – v: Show executed SQL statements.
  3. -t: display the results in text format instead of table format.
  4. – Display the results in a record format.
  5. -B: Use batch mode, meaning continue execution even when errors occur.
  6. -e: Execute the complete SQL statement, even if errors occur.
  7. -ignore executed SQL statements.
  8. -c: Do not cache the result to the client, but instead send it directly to standard output.
  9. Option: -n: Display the SQL statements to be executed without actually executing them.
  10. Before executing the SQL statement, display the current database and table.
  11. -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.

bannerAds