Navicat I think that the procedure is basically used, it is convenient, fast, intuitive and so on, many advantages, which is why I write this article. I used to basically use phpMyAdmin, but also very useful, but there are many shortcomings, such as database backup file is too large, can not be imported, multi-database server management, but also to configure phpMyAdmin, in fact, quite uncomfortable. Navicat www.formysql.com for people who just use, it is not very convenient, but it is not the same as cooked. Here's how to combine shortcut keys to make navicat more comfortable.
one, navicat how do I write SQL statement queries?
ctrl+q a SQL input window pops up and you can write SQL in it. After writing the SQL, direct Ctrl+r The SQL is executed. Also, when writing SQL statements, Navicat will prompt, Root code completion is almost , very cool.
f6 will pop up a command window, just like the root mysql-u mysql-p in, But the error will be \g when using the . Can also be queried here.
tips: These windows can be dragged together by
two, navicat how to back up, restore databases, and tables?
dump SQL file can be backed up, if you want to restore, choose Execute SQL file is OK. Backup table, the same operation as the root backup database. To restore the table, just use the Import Wizard on the line. This backup can only be produced by. sql files. If you want to back up to another file format, see Method 2.
Export Wizard will pop up a window, let you choose what kind of file to back up , Next
Import Wizard on the line. Backup table the same operation.
three, how to view table data and table structure?
double-click the table to view the table data, ctrl+d You can see not only the table structure, but also indexes, foreign keys, triggers, and so on.
four, how can I manage multiple MySQL servers?
connection button, you can connect a few more.
five, how do you manage database administrators with Navicat?
Click on the top left Manage users will pop up a window that lists all MySQL administrators. Once you have modified the permissions, you can save them.
Navicat Common function explanation