Monday 25 March 2019

How to batch multiple Queries together in Sequel Pro

I’d searched for a handful of things to solve this issue, and in the end it was quite simple.
So I thought I’d note it here.
Here are some of the terms I searched
  • 
‘Mac automate multiple sql commands’
  • 
’sequel pro run multiple queries’
  • 
‘sequel pro query window mulitple commands on run’


Here’s what the problem I was trying to solve was

I had a sql statement that was crashing, however I could run in with a LIMIT of 1000


> Click in the Query window.
> Add your query and then copy and paste the amount of rows you need. 

> Click on 'Ctrl+R'

And that’s it. 


No comments: