How to run SQL script in MySQL?

Question

In MySQL, I want to run a text file that has the SQL queries within it.

I attempted to execute source /Desktop/test.sql but received this following error:

mysql> . \home\sivakumar\Desktop\test.sql ERROR: Failed to open file '\home\sivakumar\Desktop\test.sql', error: 2

Can anyone help me with this?

Answer 1

Go to the MySQL command line mysql> you need to declare the SQL file as source.

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

Interested in SQL?  Register to this SQL Certification course and get certified.

Watch this video tutorial on how to become a professional in SQL.