How to open sql file in navicat

How to open a sql file in navicat?

1. Right-click on the left to create a new database.

Related recommendations: "Navicat for mysql graphic tutorial"

2. Select gbk as the character set.

#3. Open the database and turn it green.

4. Drag the .sql file to this database. The Run SQL File dialog box below will appear. Press Start and you can close it after the run is completed.

#5. Finally, right-click on the corresponding item in the new database in the left margin and refresh to see the contents of the database you just dragged in.

The above is the detailed content of How to open sql file in navicat. For more information, please follow other related articles on the PHP Chinese website!