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

This article mainly explains "what is the use of Navicat". Friends who are interested may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the use of Navicat"?

First connect to the MYSQL database.

1. Create a database: select the connection name, right-click, and click New Database.

2. Delete database: select the database to be deleted, right-click, and click to delete the database.

3. Create a data table: double-click test01, select the table, right-click, and create a new table

4. Modify the data table: select the data table, right-click, design the table, and then edit the fields, data types, integrity constraints, etc., just like the operations in the table.

5: delete data table: select the data table to be deleted, right-click, and select delete table.

6. Addition, deletion and modification of data:

7, query data: double-click a database, and then select query, right, create a new query, and then you can edit the query statement inside, save the query, you can use it directly in the future.

8, create a view: for example, I create a view, the view function is to display the information of post-90s stars.

Just write the sql statement in the definition, and the tool will automatically generate the view SQL

Click SQL Preview to see the SQL statement that creates the view

Finally save it and give it a name.

When you create a view, you can also use the view creation tool to create a view.

9. Add index: in the design table.

10, backup restore: first create a backup, the backup has time, you can also make notes, you can choose which one you want to restore later. The backup automatically selects all tables and views.

Restore the backup and choose your own version

At this point, I believe you have a deeper understanding of "what is the use of Navicat". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.