How do you execute a query in Sequel Pro?

Question

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?

It's right there in your screenshot. Middle-right, `Ejecutar seleción`. — ceejayoz, Nov 21 '15 at 16:54

score 89 · Accepted Answer · edited Oct 04 '16 at 22:28

89

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.

edited Oct 04 '16 at 22:28

Lemmings19

1,383
3
21
34

answered Nov 21 '15 at 15:37

Bernd Buffen

14,525
2
24
39

score 12 · Answer 2 · answered Nov 21 '15 at 15:35

12

Based on Keyboard Shortcuts:

Run all queries ⌥ ⌘ R

Run current query or selection ⌅ or ⌘ R

answered Nov 21 '15 at 15:35

Lukasz Szozda

162,964
23
234
275

score 9 · Answer 3 · answered Nov 21 '15 at 15:36

9

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

Should have the following options:

Run Current Query
Run All Queries

answered Nov 21 '15 at 15:36

David

7,395
5
29
45

score 2 · Answer 4 · answered Apr 30 '20 at 17:43

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.

How do you execute a query in Sequel Pro?

4 Answers4