amor
2/17/2020 - 7:46 AM

MySQL命令行运行sql文件

https://dev.mysql.com/doc/refman/5.7/en/mysql-batch-commands.html

shell> mysql db_name < text_file
如果已经use database,则:
shell> mysql < text_file

如果已经进入mysql,则:
mysql> source file_name
mysql> \. file_name