Detailed explanation of the use of SQLYog shortcut keys

This time I will bring you a detailed explanation of the use of SQLYog shortcut keys. What are the precautions when using SQLYog shortcut keys? The following is a practical case, let's take a look.

Ctrl M Create a new connection
Ctrl N Create a new connection using the current settings
Ctrl F4 Disconnect Open the current connection

Object Browser
F5 Refresh the Object Browser (default)
Ctrl B Set focus on the Object Browser

SQL Window
Ctrl T New Query Editor
Ctrl E Set focus on SQL Window
Ctrl Y Redo
Ctrl Z Undo
Ctrl X Cut
Ctrl V Paste
Ctrl H Replace
Ctrl G Go to
Ctrl O Open a SQL document in the SQL window
Ctrl Shift U Make the selection uppercase
Ctrl Shift L Make the selection lowercase
Ctrl Shift C Comment SQL window selection
Ctrl Shift R Delete comments from selection
Ctrl Shift T Insert template
Ctrl Enter List all tags
Ctrl Space List matching tags

Execute query
F8 Execute the current query and edit the result set
F9 Execute the current query (default)
Ctrl F9 Execute the selected query (default)
Shift F9 Execute All queries (default)

Paste SQL statement
Alt Shift I Insert statement
Alt Shift U Update statement
Alt Shift D Delete statement
Alt Shift S Select statement

Result
F11 Insert update dialog box
Ctrl R Set focus on the active label in the results panel
Ctrl L Switch the result window/table data to a table /Display in text mode
Ctrl Alt C Export table data in CSV, SQL, Excel, etc.
Ctrl Alt E Back up data in SQL dump file
Ctrl Shift M Import data from CSV
Ctrl Shift E Export Result set
Alt 1...n Select the nth tag in the results window

Show/hide
Ctrl 1 Show/hide the object browser
Ctrl 2 Show/hide the results panel
Ctrl 3 Show/hide the query window

Database/Data Table
Ctrl D Create Database
F6 Change the structure/index/view of the database/data table /Stored Procedure/Function/Trigger/Event
F2 Rename data table/view/trigger/event
Shift Del Truncate database/data table
F7 Manage index window
F10 Association/foreign key
Ctrl Alt R Reorder fields
Ctrl Alt T Data table diagnosis
Ctrl Alt F Refresh dialog box
Ctrl Shift Alt S Create database schema in HTML format
Ctrl Shift Q Restore database from SQL dump file

Enhanced Tools
Ctrl W Database Synchronization Wizard
Ctrl Q Schema Synchronization Tool
Ctrl Alt O Data Migration Toolkit
Ctrl Alt N Notification Service Wizard
Ctrl Alt S Scheduled Backup
Ctrl K Query Builder
Ctrl Alt D Schema Designer

User Management
Ctrl U Add user
Ctrl Alt U Edit user
Ctrl Shift W Manage user permissions

Personal folder
Ctrl Shift F Add the current SQL statement to the personal folder

Others
F1 Help
F12 Shortcut key window
Ctrl C Copy
Ctrl A Select all
Ctrl F/F3 Search (SQL window/result window and table data displayed in text mode)
Ctrl S Save
Ctrl PgUp Switch to the previous tab
Ctrl PgDown Switch to the next tab
DEL Delete selected
Alt L Close tag
Alt F4 Exit program

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

Detailed explanation of the use of click, touch, and tap events in mobile WEB development

How to operate the width and height attributes of the page, visual area, screen, etc.

The above is the detailed content of Detailed explanation of the use of SQLYog shortcut keys. For more information, please follow other related articles on the PHP Chinese website!