Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to implement external sql statements in mysql. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Mysql executes external sql

If you have an external sql file called "mydb.sql"; you want to create a table, assuming "mydb"

1. Not logged in:

Java code

Mysql-uroot-p1234 <'/ root/ Desktop / abc.sql'

/ / absolute path, single quotation marks can be left empty

Mysql-uroot-p1234 mydb <'/ root/ Desktop / abc.sql'

/ / enter mydb directly, and the result is the same. If the sql file does not have a use declaration, you can

2.mysql is logged in:

Java code

Source / root/ Desktop / abc.sql

/ / source is followed by the absolute path, you can

On how to execute external sql statements in mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.