![]() ![]() 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 |