#command line - How can I run an SQL script in MySQL? - Stack Overflow

[esatyabca]

Executing SQL Statements from a Text File

Executing SQL Statements from a Text File

Executing SQL Statements from a Text File

The mysql client typically is used interactively, like this:

shell> mysql db_name

However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file.

To do so, create a text file text_file that contains the statements you wish to execute. Then invoke mysql as shown here:

shell> mysql db_name < text_file