![]() ![]() Method 1: Right-click data name = "Check the 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. Second, navicat how to back up, restore database, and table? Navicat Multi-window switch, we can through, shortcut key ctrl tab, switch between the Windows. ![]() Tip: These windows can be dragged together into the ![]() Method 2: Press f6 will pop up a command window, the root mysql-u mysql-p into the same operation, but \g use will error. Another point, when writing SQL statements, Navicat will prompt, root code to complete the same, pretty cool. After the SQL is written, the SQL is executed directly ctrl r. Method 1: ctrl q will pop up a SQL input window, you can write SQL in it. One, navicat how to write SQL statement query? View or query, as shown in the shortcut keys: View Viewer, as shown in the shortcut keys: Table Viewer, as shown in the shortcut keys: Table Designer, as shown in the shortcut keys: Note: Please do not write a lot of update and delete! in a window Navicat the main window, as shown in the shortcut key:
0 Comments
Leave a Reply. |