Mysql executes External SQL

Mysql executes External SQL
 
If there is an external SQL file named "mydb. SQL"; to create a table, assume that the database is "mydb ";
1. mysql is not logged on:
Java code
Mysql-uroot-p1234 <'/root/desktop/abc. SQL'
// Absolute path, which can be enclosed in single quotes
Mysql-uroot-p1234 mydb <'/root/desktop/abc. SQL'
// Directly access mydb. The result is the same. If the SQL file does not have a use statement, you can
 
2. mysql is logged on:
Java code
Source/root/desktop/abc. SQL;
// Follow the absolute path after source.