Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of navicat database export, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Navicat is a fast, reliable and inexpensive database management tool designed to simplify database management and reduce system management costs. Next we will show you how to use naviact to export the database.

Use Navicat to connect to mysql, then select the database you want to export, right-click, select dump SQL file..., name it .sql, and save it locally. As shown below:

● chooses to dump the SQL file.

● saved locally: database name. sql

● saved successfully

What is in the usersinfo.sql:

/ * Navicat MySQL Data TransferSource Server: localhost_3306Source Server Version: 50508Source Host: localhost:3306Source Database: usersinfoTarget Server Type: MYSQLTarget Server Version: 50508File Encoding: 65001Date: 2018-07-03 15:42:50*/SET FOREIGN_KEY_CHECKS=0 -Table structure for `student`-DROP TABLE IF EXISTS `student` CREATE TABLE `student` (`student number `varchar (20) NOT NULL DEFAULT', `name `varchar (20) DEFAULT NULL, `gender `varchar (20) DEFAULT NULL, `professional `varchar (40) DEFAULT NULL, `grade `varchar (20) DEFAULT NULL, `birth `varchar (255DEFAULT NULL), `course `varchar (255DEFAULT NULL), `grade `double DEFAULT NULL, PRIMARY KEY (`student number `) ENGINE=InnoDB DEFAULT CHARSET=gbk -Records of student-- INSERT INTO `student` VALUES ('B1', 'Xiao Li', 'male', 'computer Science and Technology', 'sophomore', '1996', 'Advanced Mathematics', '500') INSERT INTO `student` VALUES ('H1000', 'Xiaoguo', 'female', 'computer science and technology', 'sophomore', '1999', 'higher mathematics', '100'); INSERT INTO `student` VALUES (' H1234', 'Xiaolan', 'male', 'computer science and technology', 'junior', '1997', 'higher mathematics', '200')

You can see that the above are all sql statements, statements for creating tables, and statements for inserting rows of data into the table. Note that in usersinfo.sql, there is only information about the tables in the original usersinfo database, but there is no information about the database itself, so when we import the sql file later, we need to set up a database named "usersinfo".

The above is all the contents of the article "navicat's method of exporting the database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.