Execute statement by shortcut in MySQLWorkbench

Solution 1:

Return = Enter key. So Ctrl + Enter key should execute.

Solution 2:

MySQL Workbench 6.3


Default key mapping

  • Execute (All or Selection) -> Ctrl+Shift+Enter
  • Execute Current Statement -> Ctrl+Enter

    Query > Execute


Change the default mapping

Open:

C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data\main_menu.xml

If you search for Execute (All or Selection) and for Execute Current Statement, you'll also identify (based on what you see in the screenshot above) the meaning of Modifier and Return:

  • Modifier = Ctrl
  • Return = Enter

Here you can change the default mappings. Being familiar with other tools like SQuirreL SQL and pgAdmin, I always prefer to run only the selected query using Ctrl+Enter or F5, so I change the following in the main_menu.xml:

  1. To run the selected query using Ctrl+Enter:
    <value type="object" struct-name="app.MenuItem" id="com.mysql.wb.menu.query.exec"> 
      <link type="object" key="owner" struct-name="app.MenuItem">com.mysql.wb.menu.query</link> 
      <value type="string" key="caption">Execute (All or Selection)</value> 
      <value type="string" key="name">query.execute</value> 
      <value type="string" key="command">builtin:query.execute</value> 
      <value type="string" key="itemType">action</value> 
      <value type="string" key="shortcut">Modifier+Return</value>
    </value> 
    ...
    <value type="object" struct-name="app.MenuItem" id="com.mysql.wb.menu.query.execute_current_statementwin"> 
      <link type="object" key="owner" struct-name="app.MenuItem">com.mysql.wb.menu.query</link> 
      <value type="string" key="caption">Execute Current Statement</value> 
      <value type="string" key="name">query.execute_current_statement</value> 
      <value type="string" key="command">builtin:query.execute_current_statement</value> 
      <value type="string" key="itemType">action</value> 
      <value type="string" key="shortcut">Modifier+Shift+Return</value>
      <value type="string" key="platform">windows</value>
    </value> 
  1. Run the selected query using F5:
    <value type="object" struct-name="app.MenuItem" id="com.mysql.wb.menu.query.exec"> 
      <link type="object" key="owner" struct-name="app.MenuItem">com.mysql.wb.menu.query</link> 
      <value type="string" key="caption">Execute (All or Selection)</value> 
      <value type="string" key="name">query.execute</value> 
      <value type="string" key="command">builtin:query.execute</value> 
      <value type="string" key="itemType">action</value> 
      <value type="string" key="shortcut">F5</value>
    </value> 

Save the file and restart MySQL Workbench to see the changes.