If it is imported, then use the Import Wizard on the line. If there are too many tables, it is inconvenient to back it up in this way. Method 2: Click on the database, the Export Wizard above the point will pop up a window, let you choose what kind of files to backup, the next If you want to back up to another file format, look at Method 2. To restore the table, just use the Import Wizard on the line. 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: Ctrl d (1): View table structure details, including index trigger, stored procedure, foreign key, unique key, (2): Copy one row.Ctrl shift r only run the selected SQL statement.Ctrl r SQL statement that runs the query window.Clever use of Navicat for MySQL shortcut keys, can greatly improve work efficiency, this experience will be classified to introduce NAVICAT for MySQL shortcut keys.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |