How to execute SQL script under MySQL

1. Write the SQL script, assuming the following:

Create Database Dearabao;
Use Dearabao;
CREATE TABLE Niuzi (name varchar (20));

Save the script file, assuming I save it in the Hello World directory on the F drive, the path to the file is: F:\hello world\niuzi.sql

2. There are 2 ways to execute SQL scripts:
The first method:
At the command line (not connected to the database), enter mysql-h localhost-u root-p123456 < F:\hello world\niuzi.sql (note that the path is not quoted!!) to enter.
The second method:
At the command line (the database is connected, the prompt is mysql>), enter the source F:\hello World\niuzi.sql (Note that the path is not quoted), or \. F:\hello World\niuzi.sql (Note the path without quotes) enter

How to execute SQL script under MySQL