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 .

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

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

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.

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

6. Add, delete and modify data;

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.

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

# 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 creating a view, you can also use the view creation tool to create the view.

#9. Add index: in the design table.

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.

Restore the backup and choose your own version

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!