Home  >  Article  >  Database  >  How to use navicat for mysql

How to use navicat for mysql

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-20 11:24:1438908browse

How to use navicat for mysql

Simple method of using navicat:

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

How to use navicat for mysql

How to use navicat for mysql

2. Delete database: Select the database to be deleted, right-click, and click Delete Database.

How to use navicat for mysql

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

How to use navicat for mysql

How to use navicat for mysql

Related recommendations: "Navicat for mysql usage graphic tutorial"

4. Modify the data table: Select the data table, right-click, design table, and then edit fields, data types, integrity constraints, etc. as in creating the table.

How to use navicat for mysql

How to use navicat for mysql

5. Delete the data table: Select the data table to be deleted, right-click and select Delete Table.

How to use navicat for mysql

6. Add, delete and modify data;

How to use navicat for mysql

7. Query data: double-click a database, Then select query, right-click, create a new query, and then edit the query statement in it. Save the query and use it directly in the future.

How to use navicat for mysql

How to use navicat for mysql

How to use navicat for mysql

8. Create a view: For example, if I create a view, the view function is to display the post-90s generation star information.

How to use navicat for mysql

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

How to use navicat for mysql

Click SQL preview to see the SQL statement that creates the view.

How to use navicat for mysql

Finally save it and give it a name.

How to use navicat for mysql

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

How to use navicat for mysql

#9. Add index: in the design table.

How to use navicat for mysql

10. Backup and restore: Create a new backup first. If you have time for the backup, you can also make notes. You can choose whichever one you want to restore in the future. The backup automatically selects all tables and views.

How to use navicat for mysql

How to use navicat for mysql

Restore the backup and choose your own version

How to use navicat for mysql

The above is the detailed content of How to use navicat for mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn