How do you execute a query in Sequel Pro?

MysqlSequelpro

Mysql Problem Overview


I want to execute a query in a MySQL DB using Sequel Pro, but I do not see a Run button.

How do I execute my query?

enter image description here

Mysql Solutions


Solution 1 - Mysql

Use +R to execute the selected Query.

Alternatively, use the dropdown that appears at the bottom right of the query editor and select Run Current or Run Previous depending on where your text cursor is.

Solution 2 - Mysql

Based on Keyboard Shortcuts:

Run all queries R

Run current query or selection or R

Solution 3 - Mysql

Use the drop down button on the right side, underneath the textarea.

Should have the following options:

  • Run Current Query
  • Run All Queries

Solution 4 - Mysql

Came here to find ⌘ + return to execute a query (like MySQL Workbench).

Found that I can map using mac Key bindings with the names of Run Current Query and Run Previous Query.

If you want to do it via terminal it would be (untested):

 defaults write com.sequelpro.SequelPro NSUserKeyEquivalents '{
        "Run Current Query" = "@\\U21a9";
        "Run Previous Query" = "@\\U21a9";
    }'

Note: you may have to restart the app.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionNunyet de Can CalçadaView Question on Stackoverflow
Solution 1 - MysqlBernd BuffenView Answer on Stackoverflow
Solution 2 - MysqlLukasz SzozdaView Answer on Stackoverflow
Solution 3 - MysqlDavidView Answer on Stackoverflow
Solution 4 - MysqlTyler ChristianView Answer on Stackoverflow