How to Execute SQL Scripts in MySQL Command Line?

Executing SQL Script in MySQL

When attempting to run a SQL script containing multiple queries, you may encounter an error while using the command source [path/to/sql_file]. This is because the source command is not recognized when using the MySQL command line interface (mysql>).

Correct Syntax

To execute an SQL script within the MySQL command line, use the correct syntax as follows:

mysql> source [full_path_to_sql_file];

Ensure that you provide the absolute path to the SQL file. For instance:

mysql> source /home/user/Desktop/test.sql;

This command will execute all the SQL queries contained within the test.sql file.

Troubleshooting the Error

The error you encountered, "Failed to open file 'homesivakumarDesktoptest.sql', error: 2," indicates that the MySQL command line could not access the specified SQL file. This could be due to an invalid file path, file permissions issues, or antivirus software blocking the file.

Verify that:

• The path to the SQL file is correct.
• You have read permissions for the file.
• Antivirus or security software is not blocking the file execution.

The above is the detailed content of How to Execute SQL Scripts in MySQL Command Line?. For more information, please follow other related articles on the PHP Chinese website!