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

This article mainly introduces the navicat database operation methods, the text is very detailed, has a certain reference value, interested friends must read!

How does navicat write sql queries?

Method 1: Ctrl+Q will pop up a sql input window, you can write sql in it. After writing sql, execute sql directly by ctrl+r. Another point, when writing sql statements, navicat will prompt, root code completion is almost, quite cool.

Method 2: pressing f6 will pop up a command window, just like when entering mysql -u mysql -p, but\G will report an error when used. You can also inquire here.

Tip: These windows can be dragged together, see below

navicat multi-window switching

There are two windows in the picture above. We can switch between them by pressing the shortcut key ctrl+tab.

Second, navicat how to backup, restore databases, and tables?

Method 1: Right-click the data name => select dump sql file to backup, if you want to restore, select execute sql file on the line. Backup tables, root backup database operations. To restore the table, just use import wizard. This backup can only export.sql files. If you want to backup to another file format, see Method 2.

Method 2: Click on the database, export wizard at the top of the point will pop up a window, let you choose what kind of file to backup, next step

navicat backs up databases and tables

If there are too many tables, it is inconvenient to backup them in this way. If it is imported, use import wizard. Do the same for backup tables.

How to view table data and table structure?

Double-click the table to view the table data, ctrl+d can not only see the table structure, you can also see the index, foreign key, trigger and so on.

How do I manage multiple MySQL servers?

Click on the connection button at the top left to connect a few more.

How to manage database administrators with navicat?

Clicking manage users at the top left will bring up a window listing all mysql administrators. After modifying the permissions, save it.

The above is "navicat database operation methods what" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to 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.