Mysql for databases (4) -- navicat for mysql and navicatmysql

Mysql for databases (4) -- navicat for mysql and navicatmysql
Navicat1. introduction:

Navicat is a software that has different software versions for different databases and supports the following databases:

 

Here I use navicat for mysql. To operate mysql in a graphical way, you do not need to manually enter SQL statements.

2. Download:

Link: http://www.navicat.com.cn/download/navicat-for-mysql

Select a different version based on your OS environment.

 

3. installation:

Basically, we agree to the agreement and click Next.

 

4. Basic operations:

A: database creation operation options

1) Open the software:

 

2) connect to the database and select mysql:

3) in the pop-up interface, set your own name (you can set your own password). Note that if your mysql is on the local machine, you do not need to set the IP address and port number, just click OK. If the database is a remote database, set the IP address and port.

 

4) after confirmation, the instance is created successfully:

 

 

5) Right-click and choose "open connection" to connect to the database.

 

After the connection, the color is no longer Gray:

 

In this way, you can directly operate in a graphical way, similar to an excel table. You do not need to use the command line:

 

However, navicat can only simplify basic operations, but it cannot be implemented if it is a table connection operation.

 

B. configuration items:

 

After the settings are complete, click "save". If you have these options, you just need to perform the operations directly. You do not need to create these commands.

 

To modify or delete a table, you can modify or delete the table.

 

 

If you want to query data, simply open the table and check the data. Or, query the data here:

 

 

Insert data:

 

 

Very convenient, right? So how does it complete this operation?

 

Right-click the table you just created and select the object information

 

Click DDL again:

 

 

That is why I just clicked so many navicat statements to convert them into SQL statements and execute them. However, navicat can only simplify simple SQL statements, but it is a little complicated.

However, navicat provides a custom function that allows you to write SQL statements on it and then forward the results to mysql. The obtained results are then transmitted and displayed using navicat. steps:

1) Select a database (corresponding to the SQL statement use Database Name). After the selected database name is selected, the color changes from Gray to Green:

 

2) Click the query button:

 

3) select new query:

 

4) A window appears, so that you can enter the SQL statement to query:

 

5) after entering the information, click run:

6) The following result is displayed:

 

If you manually perform the operation, you will find that the function of automatically prompting keywords is very convenient and practical.

 

I believe that those who have learned SQL server should have a similar feeling. Yes, this query method is very similar to the database management tool of SQL sever.