Import data to the MySQL database through the SQL File

1. enter the MySQL command line; 2. enter the password. 3. determines whether the database exists. If yes, delete drop database xxx; 4. create Database xxx; 5. use Database use xxx; (Note: The above XXX is the database name, which can be found in the header comment of the SQL file) 6. full path of the source SQL file imported into the database; for example, source D:/test. SQL; 7. close the command line. ---------------------------------------------------------------- Enter the MySQL command line and enter the password to drop database test; Create Database test; use test; source D:/test. SQL; in this way, a database test is created, and D:/test is executed. SQL statements in the SQL File